I have create a workflow to test and want to build a counter in it.
I was thinking to count in Google Sheet, how ofter a collegue will use the workflow and max it, to for example 5 times a month.
I cant seem to get it working, it doenst count and it doesnt stop the workflow with 6 or more requests.
You may have to set the object to a number in the if node like with:
.toNumber()
As it may be comparing with a string.
Where does the initial Count object come from? Form submission?
It may be easier to fetch the current count from sheets initially, and then add one to it later in the flow or earlier before the check.
Or could I also set a max. number in the sheet already and compare if that is matched, per month. If matched, the flow stops and otherwise it will continue
There is also a path that goes directly to the end without any limit checks.
This path needs to be removed, otherwise the AI agent will be triggered twice because there are two paths.
The “Clone Original Form Input” should be placed immediately after the “If” condition. To access the form’s values, a $json variable can be used with $('On form submission').item.json.
@Franz I have tried somethings and this is the closed I get.
The issue now it, it seems to be checking, but still not count in my sheet.
It felt like such an easy workflow, but somehow i struggle.