Copying some elements of dynamic page to new database

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…

Hello.

Check out this forum post to getCurrentItem and insert it in another collection: How to move data from one database collection to another

You can use update() function to change the ‘checked’ status in the ‘application’ collection.

Good luck!