04-05-2022 01:57 AM
Hi,
Is it possible to append a value from a FillTask integration onto the end of a field?
For example, a payload a bit like this:
{ "case_id": "{caseReference}", "stage_name": "{stageName}", "data": {
"textField": "{textField current value} and append something to the end of the text"
}, "ucrn": "{ucrn}", "published": "true", "submissionType":"new", "formCalculator": "true"
}
I've got a field that's a log of previous interactions and would like to add data from an external system into it if it's possible. It's a repeated stage so putting the data into another field isn't an option.
Thanks
04-07-2022 05:31 AM
you could possibly do it with an integration - I've found this is a way you can update already populated fields in forms.
Add {additionalTextField} to your target form and push your new text to be appended into that field via filltask api
create an integration to a SQL server (doesn't need any tables so any server will do) and have an integration that runs something like this:
select {textfField} + ' '+{additionalTextField} as textField
and set that to run on an autolookup within the target form.
That should then return {textField} back to the form with the new text added
04-07-2022 08:06 AM
That works thanks!
Is there any way of getting it to push into a subform field, like
{subForm/textField}+''+{additionalTextField} as subForm/textField
I've tried every combination of [] '' {} \/ that makes sense but none of them seem to work. I'm just not sure how to reference subform fields.
04-27-2022 04:54 AM
Not sure - but probably easiest to have the autolookup running inside the subform in that case and take the value form the parent form