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
------------------------------
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
------------------------------- Unfortunately, that's not possible. Formulas cannot call an API on their own, this would have to be triggered by either a user clicking a button or via Pipelines, based on the save action. What you're wanting to do cannot be done with a button click alone, so you will need to utilize Pipelines and your process will probably be something like this:
- User adds/edits a record and inputs the Registration Number
- User saves the record
- Pipelines is triggered based on Add/Modify action where [rego] has been changed
- Pipelines calls the API
- Pipelines updates the record from the trigger action based on information received from the API call
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------