Edit Record Formula Button

Question

Hello everyone,I hope everyone is staying safe out there.I'm trying to create a formula button to edit an existing record on a different table. When I created the formula initially, it brings me to the form I'm trying to edit, but it looks like a new record and doesn't have any detail of the completed form.The way I'm trying to create this button is using the parent's record ID# and the related Record ID# for the child table to create a "match". Upon thinking about this, I'm not sure if there is a way to link the parent and child records. Does anyone have any ideas about this or has done something similar? Any ideas/help is greatly appreciated.------------------------------Uchenna Ogbejesi------------------------------

MarkShnierYou · Accepted Answer

You are saying that there will only be 1 Gating Questionnaire per gate.

But even if there were more than 1, you would want to edit the most recent one.

So just make a summary field of the Maximum of the Record ID# of the Gating Questionnaires table. Now the Parent Gating record knows which child record to edit.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

MarkShnierYou · Answer

Are you looking to call up a record in edit mode?

Do you know the table alias name off the Advanced Properties of that table? Do you know the Record ID of the record you want to edit??

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community