SUM values of Make modules (Increment and variable)

How To
,
1

Hello,

I am trying to SUM values of set variable and increment function.
And I am using to use again another set variable module to run my SUM.

No matter what I do, the SUM function is not understood.

image
image3164Ă—1040 262 KB

Why am I trying to achieve this ?

Because we can not set a start value to the increment function module.
And I need it to start at a specific value and NOT the value 1 by default.
This is so I can create new rows in my Google sheet and add new values to that row.
But to save on massive amounts of Make credits I prepolpulated that spreadsheet with data filling 5K+ rows.
Therefore any new upcoming data needs to be added passed those 5k rows. I was hoping to set a row number intitally say 5001 and get the increment to work in conjunction of that to add new rows and populate new incoming data from Pipedrive CRM.

I hope that makes sense and thanks in advance for your help!

image
image4012Ă—1236 321 KB

3

Instead of a comma, you should use semi-colons to separate function parameters.

sum( 1.variable1 ; 2.variable2 )

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Learn Make

How-Tos

Useful to Know

My Custom App — Absolutely Free!

Save headaches and operations with these utility modules:

  • Chunk Text
  • Chunk Array
  • Chunk Words
  • Multiple Find & Replace
  • Collection to Array/String List
  • Execute JavaScript
  • Estimate Tokens
  • Calculate Difference Between Two Dates
  • List Upcoming Dates of Day of Week
    … and more!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

1 Like