Add link to form as a field

Question

Hello! How can I add a field that is a direct link to a form? I'd like to add the link as a button, with one button appearing for every row in a report. I expected to be able to create a field with type URL and then include the URL of the form... but it's not obvious to me what the url of my form is :). (it's not the default form for the table).

There appear to be several past posts related to this topic, and I wish I could access them! (The current service issue is preventing me from viewing them.) Any help will be appreciated! Reading the discussion posts of others has been a great help to me.

------------------------------
Chyanne Eyde
------------------------------

markshnier__you · Answer

If you just want to make a button to display the record.

Field type is Formula URL

URLRoot() & "db/" & dbid() & & "?a=dr&rid=" & [Record ID#]

Remember to provide some link text like VIEW And then I suggest you might want to make it display as a button and choose a nice color.

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

chyanneeyde · Answer

Thanks for your response, Mark. In case it may be helpful to someone else: To link to a form I used a different line of script, copy/pasted below.&nbsp;
URLRoot()&amp;"db/"&amp;Dbid()&amp;"?a=dr&amp;rid="&amp;ToText([Record ID#])&amp;"&amp;dfid=10"
And here's a resource that helped me out: https://quandarycg.com/knowledge-base/quick-base-fields-and-formulas/using-a-formula-url-field-intermediate/------------------------------Chyanne Eyde------------------------------

markshnier__you · Answer

OK, glad you are OK.&nbsp; I did not understand form your stated question that you wanted to display a record using a particular form ID#.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Add link to form as a field

Related Content

Pulling A date from anther form based on a text field name

An API(?) button to copy fields from the form, to other fields

Add child record through parent form and redirect back to parent form in edit mode

New Form Button display settings

Consolidate Field Types