Forum Discussion

LijaHarris's avatar
LijaHarris
Qrew Cadet
3 years ago

Displaying Formula - Text Field on a Code Page

I have a code page input form as a easy web intake interface for our clients.  I was able with the form wizard to grab all the input fields (example code is below).  However, I was wondering if it was...
APIs and custom code
Code Page
ChristineSuarez's avatar
ChristineSuarez
Qrew Cadet
3 years ago
If you're on a code page, you can't pull in a formula text field like you would on a form, but you can query for its value with javascript via the API (either the XML or REST if you happen to have a preference). If you're comfortable with that, I can post a code snippet up here to show you how to do it.

------------------------------
Christine Suarez
------------------------------
LijaHarris's avatar
LijaHarris
Qrew Cadet
3 years ago
I guess it could totally help if i give context to my ask.  I am trying to get the record id to populate on the code page.  That way the client has a unique ID to refer to on the intake form.  If there is an easier way to accomplish that, I'm totally open.

------------------------------
Lija Harris
------------------------------
  • ChristineSuarez's avatar
    ChristineSuarez
    Qrew Cadet
    3 years ago
    Makes perfect sense - I'll post a snippet in the morning that you can dump into your page. We can work through the rest of need be.

    ------------------------------
    Christine Suarez
    ------------------------------
  • ChristineSuarez's avatar
    ChristineSuarez
    Qrew Cadet
    3 years ago
    Another question for you - how are your users getting to this custom form/code page? Are they coming from a link on the form of the record itself? I'm trying to work out how we're going to know which Record ID# to pull in with the API call.

    ------------------------------
    Christine Suarez
    ------------------------------
    • LijaHarris's avatar
      LijaHarris
      Qrew Cadet
      3 years ago

      Apologies for responding via email will respond on the post once my internet is back.  When I go into settings then pages, when I click on view the page there is a hyperlink. So they are coming from the code page itself not the form. If there is a better way I'm definitely open. Thanks so much!!!!
      Sent from my Verizon, Samsung Galaxy smartphone
      Get Outlook for Android


    • LijaHarris's avatar
      LijaHarris
      Qrew Cadet
      3 years ago
      Here is an exmample of the code page hyperlink: https://xxxxxxxxxxxx.quickbase.com/db/xxxxxxxxxxxx?a=dbpage&pageID=3

      I have users coming from the code page because of the flexibility of the pages in utilizing not just fields and inputs but can see logos and gifs etc.  Because this database contains sensitive information, I am trying to keep everyone on the internet out of the records themselves, but I am open to the user viewing, inputting, and getting a code any way possible thats easy :)

      ------------------------------
      Lija Harris
      ------------------------------
      • ChristineSuarez's avatar
        ChristineSuarez
        Qrew Cadet
        3 years ago
        I see - so the issue is that we can pull in a record ID# for any record in your table, but we'd need to know how to target it. When a user opens the link, how do we know what record ID# should be displayed? Is it just the next record ID# available or something like that?

        ------------------------------
        Christine Suarez
        ------------------------------