I am working on a way to have one of my office staff be able to do an update on multiple records at once by clicking a single action button in a table view or an added view within my table page. Here is the case:
Our students fill out a form to requests courses. We have two learning management systems (Canvas and Florida Virtual School, FLVS) and we denote them on the form by a * in our Canvas courses. We have a page where all of the requests are put into a table that allows a direct export, scrub and then import into FLVS to enroll students. The condition that makes them show or go away within that view is FLVS Completed. Normally, once I export, I go into the builder and do an update to change all of the records with that field blank to a Yes so that view clears until the next day. I would like for my guidance secretary to do this process as she does the actual FLVS import. Is there a way to have a button that will update that conditional field to Yes on the user facing page with the export table? I would rather not give her access to the back end and my knowledge only got me to have a trigger for each record. That is not efficient as some days we get hundreds of enrollment requests. As always I appreciate everyone in here. You all help our school out immensely! Thanks!
Dan
In your Requests table, add a connection to the Connectors table, but set the validation rules so that it only connects to the one record if FVLS completed is not yes:
When this Connector update form is submitted, all of the connected Requests will have their FLVS completed field updated.
There’s a lot more you can do using a psuedo-table like Connectors, especially when you want to join together tables that don’t have a direct relationship.
Awesome directions (you would make an awesome teacher!) and this works perfectly and now I can hand off this task to someone else because we no longer need to get to the back for the process! YAY!!! Thank you thank you thank you!!!
You make sure to have a day as absolutely AWESOME as you are!!!
