How to Save Repeating Group data?

Need help
1

Hi,

I have two table in the DB - Table 1- Stock Items, Table 2 - Stock Checks

I have a repeating group that copies the data from Stock items and then has additional input boxes in the RG for the current stock level. i.e.

Stock Item, Size, Current Stock
Milk, 1L, 5

Stock Checks.png874×155 19 KB

The idea is you have a static stock list that you load up and then add current stock info against it then save it to the DB as a unique stock take.

I can’t figure out how to save data from a RG to a DB table?

Any ideas?

Simon

2

A repeating group is a list. So you will probably need to do a “Schedule API workflow on a list” and then have an API Workflow that creates the new thing.

3

Just out of interest is this done for billing reasons to get people to upgrade because this doesn’t make much sense as a way to save a list to a database. I have a paying plan so its fine it just feels like a weird way to do things!

But thanks for the info
Simon

1 Like
4

Bubble doesn’t like “loops” unless it can be sure how many times you are wanting to do something.

So “Do xxxxxx until you get to the end of this list” … might seem like a good idea until someone codes it wrong and it does it eleventy billion times shutting everyone else out of the system because we are mostly all on a shared bit of kit.

But yes, it is a bit odd at first :slight_smile: You do get used to this way of working.

4 Likes
5

Hi Simon, were you able to save the multiple entries into stock_check table with the input from the recurring group?

Could you share how you managed that. Thanks!

1 Like
6

HI Simon

How did you solve this problem? I have a similar need and its driving me insane trying to save the data in a repeating group.

Cheers

Steven

1 Like
7

The traditional way to do it is to have two data types - Stock Items and Stock Takes, and the table/data type in between, i.e. Stock Items on Orders, where you put the quantities.

But the way @Simon organized the data, the event “Input element changed” could do the trick, with the proper contitions and action to add or change things. The event is fired whenever a user leaves the input box, and you can grab the “current RG cell”.