- Summary: - I have a table that runs on a regular schedule, and I need to get the date every time that the table runs. - Background: - I have a table that is running once a [week on Sunday/day]. - I tried using moment().format("YYYY-MM-DD"), which gave the correct date on the first day that I ran the table. However, every other time that I have run the table, it never runs the formula column so I never get the current date. - Objective: - I need to get today's date, every time that the table runs.
I need to talk to a person
Table Settings: I have have turned on the table to run once per week (Run this table every: 1, Frequency: Week)
Only Selected Columns: The formula column does not appear in this list.
Date Column: I have another Date column that could work, instead of using the formula, but I am not able to choose it from the list of variables in the Claygent module.
I found this support request, which suggests that one of the variables that is given in the formula has to change before the formula runs again: https://community.clay.com/x/support/izo492yn4l9t/how-to-re-run-or-auto-run-a-formula-column-in-tool
It is very silly that we would have to insert a meaningless variable into the formula, then remove it just to get today's date.
Thanks, Smit! In that case, what's the easiest way to create a column that updates every single week when the table runs?
Smit V. Thanks for the example! Since the first rows in the table are always the same (so the company names in the table are always the same), Normalize Company Name would only run once. Can you give me an example of a dummy column that would update to a new value every single time that the table runs? I tested some other dummy values, but they didn't update every time the table runs, so the formula didn't trigger. I searched for Clay dummy columns but couldn't find anything.
Is there anywhere that I can go to make it a feature request? It seems kind of insane that Clay can't tell me what day it is each time my table runs lmao
Thanks Smit V.! I'll try these out and report back. I like the idea of calling to the free HTTP API, as long as that will run every time that the table does. Will test and report back.
