Forum Discussion
Solved
Forms and PQ - find new name and then do query functions
I am using a form to capture Licence data for volunteers. I want to have staff be able to use the form to add a new volunteer but also to update a volunteer's current data. I can see how to u...
davidmaddock54 Please have a look at the attached file. I added a query that does all in one process, by grouping and then sorting, filling in custom columns. Finally, keep only the relevant column, expand and clean-up.
Many of these steps could be "joined" together, but I kept the step-by-step approach. It's easier to follow what's going on that way.
davidmaddock54 Please have a look at the attached file. I added a query that does all in one process, by grouping and then sorting, filling in custom columns. Finally, keep only the relevant column, expand and clean-up.
Many of these steps could be "joined" together, but I kept the step-by-step approach. It's easier to follow what's going on that way.
Thanks again for this. Working perfectly in the demo form spreadsheet.