This is the same query I used to achieve the same thing with Google Sheets through Integromat: {{formatDate(now; “DD/MM/YYYY HH:00”)}}
Welcome to the community, @Rich123! :grinning_face_with_big_eyes: There are a few issue that I can see.
First, the values argument item only works inside a rollup field’s aggregation formula, and represents the values collected by the rollup. It has no meaning outside of a rollup field.
Second, the ARRAYJOIN() function only works when you have an array of items. Despite how the documentation might be written, you can’t pass in your own comma-separated values to it and combine them.
The biggest issue, though, is that your current formula only attempts to build a string based on the date in the {Scheduled} field. To actually match against specific records, the formula should return either TRUE or FALSE, but it’s not making any comparisons based on that string, so it’s going to return TRUE for everything because a non-empty string evaluates as TRUE in Airtable. My gut says that you want to compare it against Integromat’s now date using a similar format. Here’s something that I think will work for your use case.
DATETIME_FORMAT(Scheduled, "DDMMYYYYHH") = "{{formatDate(now; "DDMMYYYYHH")}}"
I built this directly in Integromat, and tested the copy-paste from there to here and back, and everything looks good, so you should be able to copy that directly to your Formula setup field in the trigger module.
Welcome to the community, @Rich123! :grinning_face_with_big_eyes: There are a few issue that I can see.
First, the values argument item only works inside a rollup field’s aggregation formula, and represents the values collected by the rollup. It has no meaning outside of a rollup field.
Second, the ARRAYJOIN() function only works when you have an array of items. Despite how the documentation might be written, you can’t pass in your own comma-separated values to it and combine them.
The biggest issue, though, is that your current formula only attempts to build a string based on the date in the {Scheduled} field. To actually match against specific records, the formula should return either TRUE or FALSE, but it’s not making any comparisons based on that string, so it’s going to return TRUE for everything because a non-empty string evaluates as TRUE in Airtable. My gut says that you want to compare it against Integromat’s now date using a similar format. Here’s something that I think will work for your use case.
DATETIME_FORMAT(Scheduled, "DDMMYYYYHH") = "{{formatDate(now; "DDMMYYYYHH")}}"
I built this directly in Integromat, and tested the copy-paste from there to here and back, and everything looks good, so you should be able to copy that directly to your Formula setup field in the trigger module.
Hi @Justin_Barrett, thanks you are a genius…!
This would have taken me 100 iterations and 10 hours to work out.
Thanks again, onwards and upwards…!
