Forum Discussion

Re: API copy a record and change some fields

HI Mark,

I tried the formula but I'm having some trouble when it comes to replacing the line below with my own information

& "&_fid_6=" & URLEncode ([Purchase Order])

Can you explain what this line is saying similar how you spell it out in your URL Buttons for Dummies app (very helpful by the way)?

I have a multiple choice field called [Type] and the field ID is 8. The options are Price, Sample, and Purchase. I want the newly created record to say Purchase.

I also have a text field called [Description] where users put in various information. I would like that field to be copied from the original to the new record.

Can you please guide me in the right direction toward accomplishing those two things?



------------------------------
Howard Fu
------------------------------

4 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    The line should read

    & "&_fid_8=" & "Purchase"


    If the field ID for Description was 99 the line would read

    & "&_fid_99=" & URLEncode ([Description])


    That field will need the URLEncode, as the contents of that field are likely to include spaces or special characters.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • HowardFu's avatar
      HowardFu
      Qrew Cadet
      Hi Mark,

      I've entered all the fields I wanted to include in this button and everything works great so thank you for that. The last thing I need to fix is displaying the record. Right now it shows that there are no errors. I believe & "disprec=1" should display the record. Is there anything I need to change or try?

      ------------------------------
      Howard Fu
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        I believe that the syntax is actually

        & "&disprec=1"

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