I suspect this is not yet possible:I have three tables:one holding the details of 1000 students,a second holding details of 120 courses,and a third recording each placement of a linked student in a linked course.(The third is necessary because we nee...
I have created a simple contract tracing app using two tables, each with a form view. The first records the name and contract details of the visitor. On submission, form 1 redirects to form 2, prefilling a sign-out field with {record_id}.
I would lik...
Setting aside the filtering aspect, for now, another way to do the record-keeping we need might be to use an automation to create a new record in the 'placements' table whenever a student is added or removed from a 'students' field in Courses to reco...
Thanks for your help Adam and Kaytee,Unfortunately neither worked for me - Adam I think yours might possibly be on the right track, but in your step 4 I couldn't lookup fields from the Placements table. Perhaps I've missed something obvious?James
Thanks @kuovonne, On2Air looks interesting.
I think the most elegant solution would be to allow forms to redirect to a formula-generated URL stored in a record field.
Step 1: Create a url to a custom form using a formula field:
Airta...
