Forum Discussion

FloridaBase's avatar
FloridaBase
Qrew Member
4 days ago
Solved

Posting from an HTML form directly to Quickbase

I would like to make a very simple HTML form (i.e., first name, last name, phone number, email address) that posts directly to a non-sensitive QB app. I am doing this in lieu of a mobile form in order to make it appear seamless on the related website, vs the more clunky mobile form link or iFrame window. I have no access to server-side configurations, so I am prepared to expose a user token in the HTML. Does anyone have any code that they could share that would give me an example of how to do this? Thank you in advance for your assistance.

api_addrecord
  • FloridaBase's avatar
    FloridaBase
    4 days ago

    Thanks for that advice.

    I wanted to close the loop on this question. Claude.ai drafted the code for me and it works perfectly. I'm attaching v1 that has the basics in case anyone else ever needs a starting point for a similar project.

  • DonLarson's avatar
    DonLarson
    Qrew Elite
    4 days ago

    FloridaBased,

    It is about 30 degrees here, so I am jealous of your location.

    Let me suggest a small variation on your plan.   Send the data to a standalone QB app that does not need a User Token.

    Then use a Pipeline to send that data to your main application.  I would even set up some cursory review of that data and check box "Approved to Export"  or something that would fire the Pipeline.

    Now you do not need to authenticate  from your HTML page and the code should be much simpler.

  • FloridaBase's avatar
    FloridaBase
    Qrew Member
    4 days ago

    Thanks for that advice.

    I wanted to close the loop on this question. Claude.ai drafted the code for me and it works perfectly. I'm attaching v1 that has the basics in case anyone else ever needs a starting point for a similar project.