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
------------------------------
Original Message:
Sent: 08-29-2020 18:25
From: Mark Shnier (YQC)
Subject: URL button fill value of proxy instead of reference field
Can you post your formula and let is know which fid is the reference field?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
Original Message:
Sent: 08-29-2020 18:07
From: Dante Tognoli
Subject: 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
------------------------------