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 possible to add a formula field to the code page?  Specifically a formula - text field that is just static text but needs to be on the code page.  Is it possible to put a formula field that is static on a code page (html/javascript):

<h2 span style="color: white; font-family: Sans-serif; text-align: center; background-color: #358281;">Customer Data Intake Form</h2><form name=qdbform method=POST onsubmit='return validateForm(this)' encType='multipart/form-data' action=https://blahblah.quickbase.com/db/XXXXXXXXx?act=API_AddRecord&apptoken=xxxxxxxxxxxxxxxxxxxxxxx>
<input type=hidden name=fform value=1>
<table class="center">
<table>
<tr><td style="font-family: Sans-serif;" class=m>Contractor Business Name:</td>
<td class=m><input type=text size=40 name=_fid_6 ></td></tr>
<tr><td style="font-family: Sans-serif;" class=m>End User Customer First Name:</td>
<td class=m><input type=text size=40 name=_fid_7 ></td></tr>
----------Where the formula - text field will go---------------------

------------------------------
Lija Harris
------------------------------
  • 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
      Christine,

      That would be amazing if you wouldn't mind posing code snippet.  I am pretty much a noob in terms of XML/REST so honestly I have no preference, whatever is easier.  Thank you so much again!!

      ------------------------------
      Lija Harris
      ------------------------------
    • LijaHarris's avatar
      LijaHarris
      Qrew Cadet
      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
        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
        ------------------------------
  • Hello. 

    I think it is not possible in the code page environment. 

    You need use JavaScript and API. 

    I have done some "crazy things" in javascript.

    Have a good day.

    Marcelo Benavides Torres