Change part of database input

Need help
1

Hello Bubblers i need help with this…

i create PriceList with PriceCriteria any PriceCriteria have OriginalString (original Number) which include on the end ID from PriceList

like this:

Energetický certifikát_Rodinný dom_yes_no_no_0_1000_5_1745932798634x865318492588474400

but i have function to copy full PriceList with all PriceCriteria and what i need i need on any new PriceCriteria add ne ID PriceList which is new created.

here the copy work flow

image
image912×565 21.5 KB

image
image872×578 21.5 KB

and here the database

image
image1940×254 31.8 KB

yellow are the unique id for any PriceCriteria
green is original PriceList
orange is PriceList which is copy from original.

  1. is possible make this changes with ( Make change to a list of)
  2. or is needed backendworkflow?

thank you

2

Hi @mj.martinjavorsky ,

I don’t know if I understood what are you really having doubt on, but answering your questions:

  1. Yes, but it’s not recommended for large lists.
  2. It depends, but as a best practice I’d choose the backend to run either “make change to a list of things” or in a recursive way.
1 Like
3

Answers to your Questions

1- yes you can use “make changes to list of things” but if list can be lengthy you think then you should go with point 2
2- this is more optimal and efficient thing you should use backend for these type of work

if you have any query you can ask freely , i would be happy to assist you.

1 Like
4

T list of changes will be like max 100 positions

5

Yes i think the option 2. will be the best but i need learn how to do it. Replace the ID with Redex or what you recommend?

6

You don’t need regex for this update. Instead you can fairly use the Arbitrary text to compose your string inside using Truncate and/or Find & Replace operator , for example.

As your list will be always less than 100 items you can use Make changes to a list of things even in the backend.