Discussions

 View Only
Expand all | Collapse all

URL button fill value of proxy instead of reference field

  • 1.  URL button fill value of proxy instead of reference field

    Posted 08-29-2020 18:08
    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
    ------------------------------


  • 2.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 18:25
    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
    ------------------------------



  • 3.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 18:32
    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
    ------------------------------



  • 4.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 18:36
    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
    ------------------------------



  • 5.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 18:44
    Yes, [Related Aircraft] is the numeric(reference) field.

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



  • 6.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:15
    Does the field for Related Aircraft have it's Proxy configured correctly?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 7.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:20
    Yes, it returns the tail # of the related aircraft in the [Related Aircraft] field. When I try to forward it with the URL button I get 20 instead. I tried a formula text field on the original form and "ToText([Related Aircraft])" and I still get 20. ​

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



  • 8.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:27
    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 Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 9.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:40
    [related aircraft] is populated with a tail #. in this case 271HC. When I use the URL button to generate the new form the field on that form (62, which is different than before because I keep futzing around with it) populates with a number instead of the value that appears in [Related Aircraft]). You can see in the generated URL below 271HC becomes 19 with the URLEncode command.

    https://lifeflight.quickbase.com/db/bqkivu2gd?a=API_GenAddRecordForm&_fid_7=08-29-2020&_fid_8=20-4022&_fid_10=Lindberg%2C%20Daniel&_fid_11=Procter%2C%20Marvin&_fid_12=Elkins%2C%20Brian&_fid_62=19

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



  • 10.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:43
    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 Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 11.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:52
    I'm creating a new record in another app when we complete a hoist. So the information is taken from the flight log to pre-fill the hoist log. The [related aircraft] field is on the flight log and contains the aircraft tail number (which it gets from another table, this works as it should). The key field in the flight log is [record id].

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



  • 12.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 19:55
    I think that someone will have to look at your app.  I have 10 minutes now if you like.  Contact me by email.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 13.  RE: URL button fill value of proxy instead of reference field

    Posted 08-29-2020 20:14
    sent

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