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.
- Wow. That looks like it'll work perfectly, I figured Grouping would have something to do with it, I should be able to follow those steps I think though.
Thanks!
