Using a formula field to open a record in another form

Question

Hi there! What am I doing wrong here.... I don't know coding but copied a sample I found out there somewhere. I'm trying to have a clickable button that opens my record in a different form - which I do have - but then when I go to "edit" in that other form (which is half the purpose of having it link here), that pop-up reverts to the starting form.
My URL formula - URLRoot() & "db/" & Dbid() & "?a=dr&dfid=15&rid=" & [Record ID#]

And ACTUALLY - while I'm here - is there a similar way to place a similar button on a linked child table? It would be nice to have one spot where this info is kept - and if I'm creating a record on the child table, I can click an action button to get to the specific Parent Form. Alternatively, if I could just pull that form in and just display it on the child table - today, I do that by manually maintaining two identical forms. I had asked QB about this, and they were looking into whether a future development might be to enable elements like Forms to be pulled like this, so that manual maintenance of two isn't necessary.

Thanks in advance!------------------------------Christine Kirk------------------------------

ChayceDuncan · Answer

For your first question - if you want them to land on the edit form go ahead and swap out dr with er in your url. So:

URLRoot() & "db/" & Dbid() & "?a=er&dfid=15&rid=" & [Record ID#]

To your second question about opening the parent from the child - it's easy enough with the same format but different field inputs:

URLRoot() & "db/" & dbid of parent & "?a=dr&rid=" & [Related Parent Value Field]

I always recommend using the table alias instead of hard coding the dbid as well

https://helpv2.quickbase.com/hc/en-us/articles/4570272019220-Table-aliases

------------------------------
Chayce Duncan
------------------------------

Sign up

Login to the community