Hi friends! I am hoping this is easy, but I'm noob enough to not even know how to search up an answer in support/forums.
My specific use is retreat registration. I have one table for Retreat Participants and a second for the possible Retreat Rooms.
The "Retreat Rooms" table has a field for the rate for Solo Occupancy, and a field for the rate for Shared Occupancy.
In my "Retreat Participants" table, I have a checkbox to indicate "solo occupancy". I would like there to be a field in the Participants table that then returns the correct room rate based on whether or not this checkbox is ticked.
Let me know if you need further information or explanation, and if you have any tips! I don't know if this is an "If/Then" or "Switch" or what 😵💫 Thank you!