Function Data "Today"

How To
1

Currently, my automation ensures that when someone fills out my form and the conversion is recorded in my CRM (RD Station), the information is automatically sent to my Google Sheets. However, there’s a limitation: in the settings, I have to choose between sending the data from the first or the second conversion.

When I opt to register only the first conversion, I encounter an issue when someone converts more than once. In this case, the tool always sends the data from the first conversion, not the most recent one, which is what I would prefer.

What I need is a solution that works like this: if it’s the first conversion, register the data as usual. But if there’s already a conversion registered before today, the tool should send the data from the most recent conversion.

Is this possible?

2

If your date is already in datetime format just use sort and first over your array.

If it is not use parseDate then sort then first.

3

Not familiar with RD station but i solve a similar issue by using a search module to list all the items in question in datetime order. Then i use a get module to get the most recent one.

Hope this helps!