Hi all,
I am having two lists,
One contains the list with all details and is grouped based on date and have separate totals columns for each date,
I am trying to validate that total column data with a date with value in another list while filling the form.
For Example,
List 1
Date | Some Data | Seating |
July 1 | Text1 | 30 |
July 1 | Text2 | 40 |
Sum | 70 | |
July 2 | Text3 | 20 |
Sum | 20 |
List 2
Date | Seating Availibility |
July 1 | 100 |
July 2 | 20 |
In the form validation,
If (List1.Sum of July 1) <= (List. Seating Availability of July 1)
then (Submit the form)
else
(Invalid entry)
Any way to achieve this.
Also, I am using List 2 to generate a chart next to the form to make the user aware of the seating availability.
Thanks
Solved! Go to Solution.
Same, not getting the sum of seats.
Deadline is the date
Invalid argument type, expecting a number value
User | Count |
---|---|
183 | |
124 | |
88 | |
45 | |
43 |
User | Count |
---|---|
248 | |
157 | |
127 | |
78 | |
73 |