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------------------------------

markshnier__you · 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
------------------------------

markshnier__you · 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
------------------------------

uchennaogbejesi · Answer

Correct, I'm looking to call up a record in edit mode. I have all the information, I'm just having trouble calling up a record from a different table.

------------------------------
Uchenna Ogbejesi
------------------------------

markshnier__you · Answer

Try this as a formula URL buttonURLRoot() &amp; "db/" &amp; [_DBID_ of the table from Advanced Properties] &amp; "?a=er&amp;rid=" &amp; [the field with the Record ID# you want to edit]------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

uchennaogbejesi · Answer

Thank you for this. I tried your formula and I was brought to a Not Found page. I think this is happening because the Record ID# for the child record isn't known on the parent record. Is there a way to get the Record ID# of the child record on the parent record? A summary field comes to mind, but it's not an ideal solution given it's flawed.------------------------------Uchenna Ogbejesi------------------------------

markshnier__you · Answer

Please provide a description of your tables and their relationship and on which table you want the button. &nbsp;Also an example would be useful and knowing what the tables actually represent.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Edit Record Formula Button

8 Replies

Related Content

Button Formula- Add child record, then hide parent record

Hide built-in 'Delete' button/option but keep ability to Delete records

Button to copy/autofill child record

Formula URL Button - update child record and parent record with user input from codepage

Create a simple edit record button

Recent Discussions

Join multi-line text field to one line

Time of Day field values are not in 24-hour format in Pipelines

Create a formula duration over 5 years

Formula URL - Edit then Add

Share your feedback on the new Qrew Discussions