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------------------------------

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

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------------------------------

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------------------------------

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------------------------------

Displaying Formula - Text Field on a Code Page

MarceloBenavide
Qrew Cadet
3 years ago
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
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
  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
    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
  Qrew Cadet
  3 years ago
  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
  ------------------------------

Forum Discussion

Displaying Formula - Text Field on a Code Page