Zoho Creator - Multi Select Options as a New form
I have a form in Zoho Creator with a multi-select field named Software. For example:
Task: Task A
Software: Software 1, Software 2, Software 3
I need to create a new form called TaskSoftware that will store each Software entry as a separate record along with the Task. Specifically, I want the above example to be transformed into:
Task, Software
Task A, Software 1
Task A, Software 2
Task A, Software 3
I need a workflow that will automatically split the multi-select values and create these individual records in TaskSoftware whenever a record is added or updated in TaskForm.
How can I achieve the above by using Deluge Script?