Write Back to Database using Spotfire Information Links

Here is a great way to write back to a relational database using Spotfire Information Links. Perform CRUD operations (insert, delete, update) directly from Spotfire using Information Links

Other ways to write back:
• https://youtu.be/smZC-FtLXYQ
• https://community.tibco.com/s/article/Writing-to-files-and-databases-from-Spotfire
• Create popup calendar: https://community.tibco.com/s/article/Date-and-Time-Pickers

Script to transfer marked data:

1. Define a passthrough data function. The data function script is a simple variable that severs as input and output. For example "x" (either R or Python) and define your x input and x output both as value strings.

2. Set the script parameters to refresh the function automatically. Your x input should be an expression limited by marking. The expression can be something like:
First([name]) & "|"
& First([age]) & "|"
& First([dob])

and your x output a Document Property that stores the resulting pipe separated string to a document property "NameAgeDob" so the output can be something like "Lionel Andrés Messi Cuccittini|32|6/24/1987"

3. Edit the NameAgeDob document property that holds the string so you can parse it to each individual document property when the value changes. So add this script after creating a document property place holder for each variable. For example, "name", "age" and "dob". The script looks like this:

strVals = Document.Properties["NameAgeDob"].split("|")
Document.Properties["name"]=strVals[0]
Document.Properties["age"]=strVals[1]
Document.Properties["dob"]=strVals[2]

4. Add a text area and insert (input field) property controls per each document property.

5. Mark rows in your visualization or table visualization and you should see how the marked rows are transferred to your document properties. From there, you can continue processing further your data, such as updating the data base or running a data function.