Hi,
I'm trying to save multiple upload document ID to an Array Field but it turned out blank in the database.
I checked the variables and they show value but nothing has been saved
I was wondering if you have a solution for this?
Thanks,
Discussion posts and replies are publicly visible
In your DB, what is the datatype of the column? what is your structure? saving multiple rows for multiple documents or saving data into a single row. If single row, you have to use join array function to save.
datatype is integer.
saving data to single row.
I tried joinArray(ri!ID, ", ") but it shows as blank because they are not text.
you should save it to text, as join array creates a string
still it did not work. still saved as null while variable is "[Document:1012]"
Could you please share some screenshots?
taxform saved as number and ssi saved as text
user interface:
Variables from Process model:
Database:
You need to make your data structure flat. You should be saving one Doc ID per row, into a single integer field. If you need multiple documents, your logic needs to create multiple rows each referring to an individual doc ID.
Other workarounds are possible, but they're much more complicated to implement and it can't really be easily explained here if you don't already know how to pull it off anyway.