URL code to VIEW record

Question

1. Have a string of code, right now it shows the record as EDIT.
what part of the code makes it EDIT?

2. How can I use the same string of code to VIEW the record?

If([Program]="CACFP", URLRoot() & "db/" & [_DBID_MEAL_SCHEDULES] &"?a=er&rid="&[Record ID#]&"&dfid=24","null")

everettpatterso · Answer

1. Have a string of code, right now it shows the record as EDIT.
what part of the code makes it EDIT?

Read about the a=er and other actions here - https://community.quickbase.com/quickbase/topics/where-is-there-a-list-of-the-url-functions

2. How can I use the same string of code to VIEW the record?

Change the a=er (Edit Record) to a=dr (Display Record), like this:

If([Program]="CACFP", URLRoot() & "db/" & [_DBID_MEAL_SCHEDULES] &"?a=dr&rid="&[Record ID#]&"&dfid=24","null")

Forum Discussion

URL code to VIEW record

1 Reply

Related Content

View all Parent records and related Child records in single table view

Replacing Hard-Coded Parameters

Google API QR Codes not working?

Button: save the new record and edit the new record

Passing Record Info to Code Pages

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