Incremental value every run

Hello, I would like to create a workflow that run every x time, set a start value y of 500, and use it in http request…
the point is, every time the workflow run, the initial value y must increase by 500.
1 run 500
2 run 1000
3 run 1500
etc…

I’ve tried a lot of solution but didn’t find the right way, i am sure it’s an easy function…
thanks for the help!!

Hey @Gabriele_Bracciali,

What sort of things have you tried? Is the value of y something that would need to exist for the run of the workflow or would it be increased on each workflow run?

I’ve tried this

and also to put +500 in the input value
I need this value for run an http request each run

Hey @Gabriele_Bracciali,

Is that each run of the HTTP Request then instead of the workflow itself? I need to understand which it is as the answers are very different.

yes i need this value only in the http request, and should increase every run of the node
every http request should run based on an interval node

Do you have an example of your workflow?

Yes i have it, but i think it’s useless, cause it’s only an http request. and after the rest of the workflow do stuff, but doesn’t impact with this part.

Hi @Gabriele_Bracciali,

To increment in each execution a value of +500 you should set up a workflow that saves that value in some kind of database or a simple Google Sheets file to be able to retrieve it in each execution.

In the following sequence, you bring the last value of a table in Baserow, add the value 500 and save it again in the same table, so that in the next execution the workflow will start at 500,1000,1500, etc.

:wink:

1 Like

@martinhache hi, thank for reply.
yes, it’s look like what i need, i will try

If the value only needs to exist in the workflow for that run and increment on each loop of the workflow you can use something like this.

If you want to persist it between workflow runs as it is just a small number static data would be a good way to go.

2 Likes

Same operation in Google Sheets…

:wink:

thanks @Jon , but i think this is not for what i want

okay nice, i’ve tried but the first google sheet node doesn’t work, it return me an empty item

Hi @Gabriele_Bracciali,

Have you defined the column name and assigned a first value, e.g. 0?

Screenshot 2022-10-07 at 17.32.49

Hi @Gabriele_Bracciali,

Define the column name in cell A1, and then assign the first value 0 in cell A2.

image

done it, okay now the function return me this
edit:
it was my problem, cause i was using another “Item Lists” in the workflow @martinhache

What is the name of the previous Item list node?

It was Item List, and when i past your nodes, the Item list takes the name “Item List2” , so i’ve change the name in the function, and it’s working

Great. I hope you found it useful :+1: