Forum Discussion

DanteTognoli's avatar
DanteTognoli
Qrew Captain
6 years ago

URL button fill value of proxy instead of reference field

I have a URL button that populates a number of fields on the form it creates. The problem is I want to forward a reference field but I am getting the value for the reference instead of the value in the proxy field for that reference. Is there any way to forward the proxy field instead?

------------------------------
Dante Tognoli
------------------------------
APIs and custom code
Buttons

12 Replies

    • DanteTognoli's avatar
      DanteTognoli
      Qrew Captain
      6 years ago
      fid 36 is the reference field

      //[hoist completed] is a checkbox
      If([Hoist Completed?] = true,
      // next line generates a new record in the database in quotes
      URLRoot() & "db/" &"bqkivu2gd"& "?a=API_GenAddRecordForm"
      //fid 7 = [Hoist Date] on the new form, prefills this field with the date from the referenced field [Date] on the form where the button exists
      &"&_fid_7=" & URLEncode([Date])
      //fid 8 = [Flight Number]
      &"&_fid_8=" & URLEncode([Flight No.])
      //fid 10 = [Pilot]
      &"&_fid_10=" & URLEncode([Pilot])
      //fid 11 = [Nurse]
      &"&_fid_11=" & URLEncode([Crew1])
      //fid 12 = [Paramedic]
      &"&_fid_12=" & URLEncode([Crew2])
      //fid 36 = [Aircraft]
      &"&_fid_36=" & URLEncode([Related Aircraft]))

      ------------------------------
      Dante Tognoli
      ------------------------------