I am trying to update a small database table with 6 items that are selected from a repeating group. The repeating group holds property names from a much larger table and one of the field’s is named Selected (yes/no).
The small table has only 6 records with each record having a number field (called pin-number) containing on number 1 through 6 and a Property Name field to match that of the larger table.
Because I cannot view into the RG, as the 6 items are selected, the Selected field in the larger table is updated to “Yes”. I can now use this list of “Selected” records (sorted by Name) to add their Property Names to the small table, one name per record with the first sorted Name to the record with pin_number 1, and so on.
What I’m having trouble with is breaking out the list of sorted names into individual records. Right now, I get the complete list of names into each of the 6 record’s Property Name fields.
This is the workflow step that populates the Property Name field with a list instead of a single name:
This is the result (should only be a single name):
I’d be grateful if anyone can tell me how to parse the list into individual records.
Try parsing for one item such as “search for property´s first item Name”
Thank you, however that leaves me with the same Property Name for all 6 records…
Got it. Perhaps you can review the overall logic, or zoom in on a logic that allows you to go one by one to address each of them.
Pretty sure that you could do the above without a recursive flow. But, if this introduces another course of action to the logic you are building … I throw it out there just as a … for your consideration. 
Thank you…the one-by-one logic would be great if I didn’t require the information in the small table to be in alphabetical order. The next steps I take with this data requires a 1-to-1 relationship between the alphabetical name and the numerical pin_number data.
The other issue with that selection process, whereby 6 property names are selected, occurs inside a repeating group, which I cannot see into once I’m at the workflow level. At least, I seem to have the same trouble getting the data split up since the RG spits out the data as a “List of Property’s”.
This sounds like a use case for extracting data, transforming it, and use it for the next step. If you go this route I suggest to do so on the page as much as possible to avoid back and forths with the dB which may slow things down.
I agree with that approach and that’s the reason for my question…how do I, in bubble, do exactly that?
you can use custom states on the page to hold the information and you can make them a list. you can also use list item number to track the pin number because if they get added to the list in the same order the pin number is created then they item number will match the pin number
