Berto2002 Posted October 6, 2021 Share Posted October 6, 2021 Mapping Fields from Customised Forms - Hornbill states, "DATETIME custom fields 21 - 25 each suitable for holding a single date-time stamp (YYYY-MM-dd HH:mm:ss). These columns should ONLY be used in conjunction with a date-time picker." I want to start to capture the ACTUAL start and end of the work on a Scheduled CR so we can assess compliance with the schedule. We have "Start Implementation" and "End Implementation" Human Tasks to give us the point in time. I was planning to use a Get Timestamp Cloud Utility node directly after each of those Human Tasks and map that result to a custom field (one of 21 to 25) but due to the warning in the Wiki page I am concerned about that. Do I need to manipulate the Get Timestamp node result (with a String Util?) before it will be compatible with the custom field 21-25 formatting? Regards, Berto Link to comment Share on other sites More sharing options...
Victor Posted October 6, 2021 Share Posted October 6, 2021 47 minutes ago, Berto2002 said: Do I need to manipulate the Get Timestamp node result (with a String Util?) before it will be compatible with the custom field 21-25 formatting? No, it works fine... as long as the returned value is in the compatible format. The Get Timestamp node returns two params: When hovering over the icon it shows some info including the format returned as value. Both params have values that are compatible with the format required by date/time custom fields in requests table. As a note, if you would need to manipulate the value, is not the string utils that I would recommend, there are special nodes that format various date/time values (the "Date Formatter" util node) 1 Link to comment Share on other sites More sharing options...
Berto2002 Posted October 6, 2021 Author Share Posted October 6, 2021 If you have access to update your Wiki you could update: "These columns should ONLY be used in conjunction with a date-time picker or with the Get TimeStamp Cloud Utility" Link to comment Share on other sites More sharing options...
Victor Posted October 6, 2021 Share Posted October 6, 2021 I'll look into making the documentation more clear/detailed. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now