How to add marked (selected) rows from a repeating group to the Database

alcompstudio · 2025-01-24T17:58:11.246Z

Hi, dear experts! I have a problem of this kind. I am displaying data taken via API and outputting it simply in the Repeating Group in text form (matching the text of each conditional field/parameter).
I need to:

Checkbox the rows (I implemented this via Custom State and put the checked rows in the Custom State list)

image1898×818 99.9 KB
The checked rows need to be written to the Database - i.e. create a Thing for each checked row (probably via loops). This is what I don’t understand how to do… How to extract the selected data from the list of custom stats, to loop through them and enter only the necessary records into the database. As a unique parameter I use the text value ID (on screenshot - 2, 3, 5), according to which you can compare the selected rows (since they are not in the database yet, there is no unique identifier).

I hope I’ve made it clear… Perhaps someone has solved a similar problem, or there are similar questions - I will be glad to help.

alcompstudio · 2025-01-24T18:29:39.453Z

I forgot to mention that there should be a bulk addition of checked cells with just one click of the “Add Selected” button

davidb · 2025-01-24T18:35:26.640Z

Schedule API workflow on a list

alcompstudio · 2025-01-24T18:56:31.805Z

Yes, I know that I need to use the scheduler API, my question is - how do I add selected records, i.e. with IDs 2, 3 and 5 in my example (only 3 records from all list)? How can I set a condition/filter so that information from rows with these IDs and not any others will be written to the database?

image1558×639 68 KB

davidb · 2025-01-24T19:23:24.543Z

Presumably, the list for the SAWOL action is your “Custom State list”.

alcompstudio · 2025-01-26T14:41:56.206Z

And if I don’t want to (can’t) use, maybe I want to use e.g. Simple Looper to create a list of things. But I don’t understand how I can “grab” only those rows that are checkboxed (i.e. those that are in the Custom State List). I would at least know how to create one thing that is in the Custom State List, for example with ID 2 . How to “pull out” this particular one? I will go further down the list for each “element” in the custom state. But I need this “primary” condition for selecting an element from the list.

UPD.

image1049×590 29.1 KB

Here I’m trying to create a new thing and populate the ID field with the value that is in the “field” of the external API - ID, and matches any of the values in the Custom State List (I also tried to specify the first value from the Custom State List). But for some reason my expression doesn’t work, it always takes only the first value of the ID from the List API, but not what I want to take from the Castom State List.

That is, for example, in the Castom State List there is a value 2, and I want the ID field to be filled with the value 2 (but it is fundamental to take this number from the ID field of the external API, because I plan to fill the fields of other values from the external API by this comparison.

alcompstudio · 2025-01-26T17:28:21.148Z

I found a solution (possibly the right one, but not sure) by using the :filtered option

image1010×540 35 KB

alcompstudio · 2025-01-26T17:35:31.273Z

Now I have the task of adding a list of items to the database table, only those that are “checkboxed” (i.e. placed in the Custom State List) - using the free Simple Looper . I think to make a variant that at each iteration of the loop to delete the first value in the Custom State List, while the “second” value in it will be moved to the “first” place. This will “search” all values until all of them are deleted (the loop will be stopped). Can you tell me if there is logic in this method, or if there is another solution (do not suggest the Bubble API scheduler, I want to do it with the Simple Looper loop plugin or its analog) ?

davidb · 2025-01-27T01:04:46.576Z

I don’t follow your explanation nor the need for anything like Simple Looper. I interpreted that your “Custom State List” is a list of precisely the items for which you want to create new database records. That would be a very typical way to accomplish your goal–i.e., use a workflow triggered by the user’s (de)selection of a row to add or subtract that row’s item from a dedicated custom state that is a list of such items, and then use that custom state’s list of items as the input to a SAWOL action. Of course, I may be misunderstanding your current setup.

alcompstudio · 2025-01-27T10:40:26.306Z

Thanks for your replies and trying to help me, I found a temporary solution for myself. Perhaps this is just my particular case and not suitable for everyone.

system · 2025-04-04T17:58:35.640Z

This topic was automatically closed after 70 days. New replies are no longer allowed.