May 03, 2023 08:19 PM
Hello! I am trying to complete a check-in form that takes in student ID (as the key), personal info (name, email, etc.), and the current project (ex. using 3D printer). I am trying to find a way so that what the student inputs their ID (the table's key), the personal info doesn't need to be filled in, just the current project fields. I don't want multiple records of the same ID to be combined (so not dedupe extension) but for the ID recognition to autofill the personal info fields.
I've looked at the 'No-Conflict Asset Reservations' template from @Kamille_Parks but am 1. confused on how to adapt the code to my needs, 2. worried that it doesn't integrate into the form that would be available to students. Thanks in advance!
May 03, 2023 08:51 PM
You could use two tables. The first table is the details for each project. That table is linked to the second table, which holds your student information with the ID as the key. In your first table, you can have lookup fields that, once the ID from the second table is linked, all those student data is filled in. Create a form in your first table that students fill out, and they start by choosing their ID which is coming from the second table.
The key to preventing duplicate projects is to create two views in your second table. The first one filters by students who have a linked record from table one and the second view is the students without a current linked project.
In your form, under the field where they choose their ID, set it to use the view that has unlinked projects. Now what happens is that when they open the form, and choose their ID, they will only see it until they submit the form. Once they submit the form and have a linked project, their ID falls out of that view.