Inputs update in database... if input has not changed

Rookie question perhaps…

I have a form for the user to input all values of a golf course scorecard values (PAR, Hole Handicap, Distance). This data is multiplied 18 times (for 18 holes) and 10 times for 10 different tee box colours. Most golf courses will have only 5 different tee box colours.
When the user saves, I update every single one of those fields in a database thing.
image

One of 180 workflow action (18 holes x 10 Tee Box colours). I do a create with a condition that it does not yet exist and a Make Change action when it does.

Here’s a sample of my scorecards (Black and blue Tee Boxes).

I could not figure out a way of doing one action per hole number per tee box colour.

Question: If the form input has not changed, will the update skip that action in the workflow or do it anyways?

Thanks.
Guy

I would love to have a way to loop through these, therefore reducing the number of workflow actions substantially.
Users are Golf Club Managers. I do have other users who are Golf players . Those players do not edit the golf score cards.

Note: I do not save input data for tee box colours that the user has not selected. If a user does not use the black tee boxes on their golf course, then I do not save the black values.

Wait… are you saying you have a workflow with 180 actions to do this!!! ??? !!!..

Surely a recursive workflow with 3 or 4 actions action could handle all of this much more efficiently? …

In any case, I’m not entirely sure I understand the question, or the specifics of what you’re doing…

But if you were to use a recursive workflow for this it should be pretty simple just to create new database entries or modify existing ones based on whether they exist or not.

Thanks Adam.
OK. I will study recursive workflows. Never used it.
Any suggestions of where I could learn about them?
Guy

I’d start with this: How To Set Up Recursive Workflows In Bubble - Amlie Solutions

and this: Tracking The Progress Of Recursive Workflows In Bubble (amliesolutions.com)

Perfect!
Really appreciating your help!
Have a great day.
Guy

1 Like

I actually bought his two books.
Study time!! :slight_smile:
Guy

1 Like