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.
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
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.
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.
