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

Related Content

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

Approval Button redirect to View Form

Color Code Date Field based on Formula

Color Coding based on field value

Using Grid Edit to Edit Multiple Records at Once