Hi, we have an appsheet app for registering users to a night class and to also add the user each time they return on subsequent classes. The app has two sheets in a workbook. First sheet is for New Guests/Registrations and the second sheet is when the user returns called ‘Returning Guests’. The two sheets are linked by a reference field ‘Name’.
The New Guest sheet captures there name and if they can gift aid. If they didn’t fill the gift aid
information in we would like to ask them again on the returning Guest sheet. I have created a slice of just the gift aid fields to be filled in from the New Guest sheet called Gift Aid.
Is it possible to do the following?
- when a Returning Guest completes the info on the Returning Guest
form to then take the user to the relevant users row/record on the Gift Aid slice created from the New Guest sheet?
( on the UX Returning Guest View there is Event Actions: Form Saved:
View Ref(Name) option - however this takes you to the full record and I only want to show the Gift Aid fields)
- I also only want to show the Gift Aid slice if the Gift Aid field is not filled in on the New Guest sheet for that user e.g. (isblank(giftaid)). Is this possible in this scenario?