Correct syntax for forumla
Hi all... I have text field that I am trying to pull data in from outside via an API call as the result of input from a field called REGO. Text formula is.. https://www.carregistrationapi.c...
Forum Discussion
If you're building a Text formula, you have to put anything you want "hard coded" into double quotes and then connect your pieces with ampersands, like this:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
"this is some text I want printed" & [some field] & "here is some more text I want"​------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- Hi Blake.
The output from above is via JSON so still unsure how to structure the syntax.
Cheers,
Damien
------------------------------
damien page
------------------------------- Ok, so let's back up. The URL that you're wanting to build - how are you planning to use that? If you're wanting to connect to an external system using their API and then use the response to Post data back to Quickbase, you'll have to use Pipelines or similar automation service to do this. If you use Pipelines, you don't need to build a Formula Text field to generate the URL on the table, you can just build that right in the Pipeline setup.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- Hi Blake.
Our users in the field would type in a vehicle registration number [rego].
Then ideally, the vehicle type field would be generated as a result of JASON response from the API call.
All details would need to be completed prior to the form being saved.
------------------------------
damien page
------------------------------
