I have a gallery that is part of a repeating row (table) in the gallery. I have 4 checkboxes in the gallery breakfast, lunch, dinner, all.
I need to be able to click on the All checkbox and have it select all of the other checkboxes. I need it to be IN the gallery because it is a repeating row and not an outside button.
Can this be done?
Thanks
Solved! Go to Solution.
Ok I figured it out. I have my closing parenthesis in the wrong spots works perfect now.
ext(Sum(If(Checkbox3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Breakfast))
+
If(Checkbox3_1.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Dinner))
+
If(Checkbox3_2.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Lunch))
+
If(Checkbox3_3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Incidentals))
)
,"[$-en-US]$#,###.00")
So I sort of have this working,
Text(Sum(If(Checkbox3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Breakfast)
+
If(Checkbox3_1.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Dinner)
+
If(Checkbox3_2.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Lunch)
+
If(Checkbox3_3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Incidentals)
)
)))),"[$-en-US]$#,###.00")
However, it is really not responding like i want so the first two Breakfast and Dinner will add up and ALL will add them all, but I need it to provide the total if just lunch and dinner or breakfast and Lunch.
I am close just missing something somewhere.
Ok I figured it out. I have my closing parenthesis in the wrong spots works perfect now.
ext(Sum(If(Checkbox3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Breakfast))
+
If(Checkbox3_1.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Dinner))
+
If(Checkbox3_2.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Lunch))
+
If(Checkbox3_3.Value=true, LookUp(PerDiem,DESTINATION=drpCity_3.Selected.Result,Incidentals))
)
,"[$-en-US]$#,###.00")
Thanks for sharing your findings!
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |