What are you trying to achieve?
So, i want to ultimately create a scenario that does a lot of things, creates runsheets, dropbox folders, filerequests and so on
I have tried with both chat-gpt and make’s “own” ai, but both seem a bit retarded (mostly)
Steps taken so far
Step 1 - Watch for new events in g-cal (WORKS)
Step 2 - Filter out an emoji for the next step, using a set variable, and this “code” (WORKS
{{if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; if(contains(1.summary; “
”); “”; ))))))))}}
now, in Step 3, i want Make to gather the highest number from column b, which looks something like this, Using “get range values”
ROW 2: #1045
ROW 2: #1047 (notice how 1047 is above 1046, this would be because i have re-ordered them)
ROW 3: #1046
Etc
I want make to gather ALL numbers from column B
From Cell B2 all the way til the end, which i don’t really know, as this will change over time, so it needs to be “modular”
i then want make to find out which number is the “highest” in this example, it would be row 2 with 1047, i want 1047 to go through to the next step as “id” i would then be able to have a set variable which outputs the value from the “get range value” and then +1 so the variable would be 1048.
This to me seems super simple, and i’ve tried and tried, but neither me, nor EITHER AI can solve it, they keep japping on about aggregators and so on, but i get the same result every time.
Also, is there any module that can just show the output? like a text-field that would just show what i input to the module?
Thank you in advance
