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------------------------------

Can you post your formula and let is know which fid is the reference field?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Is fid 36 a numeric field type? Is it the field for [Related AirCraft].------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Does the field for Related Aircraft have it's Proxy configured correctly?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

I'm now confused about the symptoms. You have a field for [Related Aircraft]. It is field ID 36. What value is being populated into that field? Is part of the tail number being populated into that Field. Can you post the actual URL that is being generated by the button?------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

So I'm still confused. You are trying to populate the field for Related Aircraft. I suppose that you are launching off the Aircraft record and creating a child. What is the Key field of the Aircraft table? Is it [Record ID#] or [Tail #] ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

URL button fill value of proxy instead of reference field

MarkShnier__You
Qrew Legend
5 years ago
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
------------------------------
- DanteTognoli
  Qrew Captain
  5 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
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    5 years ago
    Is fid 36 a numeric field type? Is it the field for [Related AirCraft].
    
    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

Forum Discussion

URL button fill value of proxy instead of reference field

Related Content

Reference tables quandary

Tracking References and Definitions

Reference Numbers Displaying Instead of Names in QuickBase

Delete Formula Button Error

API Button Help