URL code to VIEW record

  • 0
  • 1
  • Question
  • Updated 1 month ago
  • Answered
  • (Edited)
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")

Photo of Rilana

Rilana

  • 20 Points
  • totally out of sorts! coding is not my thing!

Posted 1 month ago

  • 0
  • 1
Photo of Everett Patterson

Everett Patterson

  • 802 Points 500 badge 2x thumb
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")