I am creating a party attendance form with a yes / no field for attendance.
I have managed to set the other aspects of the form to update the database with the correct information, but I can’t seem to work out how to do it with the attendance yes / no option.
When I set the
“Make changes to User”
to
“Attending = Dropdown Current User’s Attendance isn’t valid”
it always updates the DB to the user not attending, while if I set it to
“Attending = Dropdown Current User’s Attendance is valid”
it updates the DB to the user attending, but I can’t work out how to get it to update the DB based on the dropdown itself.
I tried it with both:
“Attending = Dropdown Current User’s Attendance isn’t valid and Dropdown Current User’s Attendance is valid”
The “is valid” operator is used to determine if something has a valid value, like if the dropdown wasn’t allowed to have an empty value but it was, it would be considered invalid.
So in this case you don’t need to reference if something is valid or not.
But your next issue is a Dropdown is text, and your Attending field is a yes/no. So what you need to do is Make changes to UserAttending = Dropdown Current User’s Attendance is "Yes” (manually type Yes or whatever your Dropdowns yes will be called)
So if the dropdown’s value (text) is “Yes” then it will return the proper “yes” for your database field. If it is not “Yes” then it returns the proper “no”
Hi Tyler, thanks for that - I tried it several times, it didn’t work initially, I think because I hadn’t capitalised the Y in Yes, but I got there in the end.
