I want to create a record every day with today’s date entered. I set the field as a date type and want to input today’s date at a specific time each day. When using Create Record, what formula should I use for the date field to make this work?
Hi @Headchef.Yang , you can set up a scheduled trigger to run daily at your desired time, and add a Create Record action.
In your datasheet, add a field of type Created Time — this field automatically records the timestamp when a record is created. That way, every time the automation runs and creates a record, the field will already contain that day’s date without needing to manually input it.
Hope this helps.
I’m currently trying to enter a date into the first field. However, using the method you suggested, I wasn’t able to insert the date directly into that field. As a workaround, I used a formula in the first row to retrieve the date. The issue I’m encountering is that all existing data seems to be removed, and only newly created records have the date applied. Could you please let me know if this is the intended behavior?
Hi @Headchef.Yang
Question1:When other field types are converted to smart formula fields, the existing data in the current field’s cells will be automatically cleared
Answer1: This is the expected behavior and works as intended
Question2:When the smart formula is used to retrieve a date, the date currently only appears in newly created records
Answer2:This is a known issue, and we will work on fixing it. We’ll notify you as soon as the fix is released.
Sorry for the inconvenience caused, and thank you for your feedback