I currently have a database where users can fill out a form and submit. The database fills correctly, and there are no issues.
However, these applications have to be gone through, so I have a staff page, which successfully filters by application.
There are two things I want to be able to do.
When the staff member fills out the short form to confirm or deny the applicant, I want an entry to be submitted into a NEW database, which is easy if that were all, but I would also like to take elements from the application and insert them into the new database as well. I’m having trouble grabbing elements from the “application” DB and putting it into the “checkedByStaff” DB.
Additionally, after staff submits the check, I’d like to change a boolean in the original “application” DB to say “checked,” so that it can be filtered out of the “needs to be checked” page.
I’ve googled this a bunch and have settled on the fact that I have to create custom code for all of this, but I’m very unaware of how to do so…