How to reduce Workload units

bri.bubble01 · 2024-10-01T02:08:16.307Z

I want to make the Sales table per day and per customer( below picture).

Now, set workflow like below.
①the create table button clicked, set sate 「customer_list：do a search for customer」「date：date timepicker’s value change date to 1 & time to 0」
②schedule API workflow
③create a new temporary type
D1 = do a serach for sales type filtered price sum (date=1, customer code= first items)
D2 = do a serach for sales type filtered price sum (date=2, customer code= first items)
D3 =do a serach for sales type filtered price sum (date=3 customer code= first items)
④Schedule API
customer_list muinus items first item
only when customer_List_count > 1

This process works without any problems.
However, just one operation consumes 1000 workload units.

Please let me know how to reduce workload units consumption.

pictureA1126×498 62 KB

pictureB1143×757 58.5 KB

pictureC1024×702 49.2 KB

Jici · 2024-10-01T02:19:36.812Z

First step is to lookmif you can change for a achedule workflow on a list (sawol). The other option could be to use trigger event instead of schedule workflow

bri.bubble01 · 2024-10-01T02:29:19.228Z

Thanks your reply.
you mean that don’t use backend workflow?
How can I set the workflow without backend workflow.

Please show me the detail method?

Jici · 2024-10-01T02:44:21.143Z

No . You continue to use backend wf. But instead of doing a recuring wf, schedule wf on a list instead. Or use DB trigger to create your daily thing. I’m on mobile, so it’s hard to detail, but there’s a lot of example on the forum. Also, using a DB type:minus item is a bad practice actually. Better to use a list of text and store the unique_id. Look for recent topics from @boston85719 or @georgecollier and me about using sawol.

bri.bubble01 · 2024-10-01T02:51:54.924Z

I understood using backend wf.
but I don’t know how to set “schedule wf on a list instead. Or use DB trigger”.
I’ll take a look at the topics you introduced.

If you have a time after, please show me how to set method.
Thank you very much.

system · 2024-12-10T02:08:51.426Z

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