So, I am adding new features to an app I am writing for a volunteer group. Using the "Todo" app as a model, I have a form with a single dropdown list. It is a rowlink to the "Quilters table. The form then shows any quilts with the current user field set to the user selected in the dropdown list.
I then added checkboxes (like the Todo app) so that the user can select which quilts they want. When a given checkbox is clicked, the row is changed to have a "Temp User" set to the user in the dropdown list.
The page then moves that quilt to a 2nd list, and is removed from the top list of quilts.
All of this works just great. Where I'm running into a lack of knowledge of how to approach the final part of the form is this:
When the user clicks the "Done" button at the bottom of the form, I want to update the rows that are in the bottom list. For each one, I want to:
- Set the "Current Owner" field to a specific user "ESQ" (that is already in the Quilters table.
- Set the "Temp User" for each of these rows to "" (Empty string).
Not quite sure how to do this. I'll attach, if I can, a screenshot of what it looks like. Hopefully, you can point to a routine that I can use as a sample to finish this code for the users.
Thanks!
Marty
P.S. If you want to look at the feature, it is the "Receive Quilts" page in the app.