Date field not populating with Automations - trying to copy a week's worth of time sheet data for the next week

Question

I'm attempting to allow the users to copy their time sheet records from one week to the next as a means to pre-populate their time sheets. At this time, I have my automation create a new record and copy the Related Project and the Related Employee successfully. However, there is a Formula Date Field called "+7 days" that takes the time sheet Date field and adds 7 days to it. When I try to have this "+7 Days" date copied over to the new record Date field, it comes in blank. Not sure how to get the automation to populate the Date field with this future date as intended.

eomdevelepors · Answer

Automatons were limited to date fields.&nbsp;

quickbasecoachd · Answer

Can you explain what you mean by this comment?&nbsp; Automations should be able to update any data entry field type.

eomdevelepors · Answer

The automation trigger does not allow you to trigger based on a date field.

You can read that in the documentation as well. I have a work around for it but it may time out on you anyway since it needs to lookup to many records which will be longer than the 30 second timeout of an automation.

Hope this helps.

quickbasecoachd · Answer

I tested an automation and it let me select a date field as a trigger.&nbsp; Are you saying that date fields are not offered as trigger field for you?

eomdevelepors · Answer

That is correct. I tested it again.&nbsp;Here is a copy of the documentation:Fields and tablesSome field types are not fully supported in an automation:Address fields and their subfields are not currently available in automations.File Attachment, iCalendar, Report Link, Time of Day, VCard � Fields of these types are not included in the list of fields you can retrieve data from in an automation.Date, Date/Time, and Duration fields cannot be used when defining conditions for an automation trigger or when choosing which records to modify or delete in an automation action.

Forum Discussion

Date field not populating with Automations - trying to copy a week's worth of time sheet data for the next week

Related Content

Trying to calculate On Time delivery

Trying to Create a Attendance Checklist

Trying to create a report with an ask users filter, but with a multiselect

Auto populate prefilled records

Automating Manager Approval via Email