My app has a data type called Judges.
I want to be able to paste in a list from excel of names, and create new Judges in the database if necessary. (I believe that if I just import these it will create duplicates)
The plan at the moment is to have a multiline input that I can paste into, then I need to process each line, search for a judge with that nae and if it doesn’t exist, create it.
How can I do this?
I tried a custom state bit cannot get the state to hold a list of text items.
I also tried a repeating group that then had the judge name from the input, then a search/count text item and an add new button so that I could at least quickly add new judges but still cannot get the repeating group to use the list from the multiline input.
Any advice?
You can use the value of the multiline input, split that by a new line to get a list of texts, i.e names of judges
Do this
Create a backend workflow that accepts a text (name) as a parameter. Within this workflow, add an action to create a new thing only when the judge with the name doesn’t exist
When you click the save button on the front-end, add an action to schedule the said backend workflow on a list of things, with the list being the multiline input’s value: split by a new line
Thanks, that is what I am trying to do, but I cannot seem to get a ‘list’ of things from the input, only a large ‘blob’ of text.
If I have a button and add a workflow to this button, choose make changes to a list of things, I cannot add the list from the multiline input as it is incompatible.
It’s feeding the create a new thing workflow with the list that I am struggling with.
