+1I am trying to use a timestamp field from Onfleet to populate this Actual Pick Up Time field
But when I create the update airtable action, this field is not showing
these two fields above are formula fields derived from the Actual Pick Up Time field that is not showing in the list of options.
Any thoughts?
Best answer by chrisfinck
Oh I figured it out, I needed to format the date into the one that has the T in between it because that's what airtable accepts. Thanks!
+1Try the button at the bottom
No dice I had tried that :/
+14Did you do a ctrl+find in the browser to see if there is a match for the field name?
Fields show up in the order in which they were added to the Airtable Table.
Check the Airtable API to make sure the field appears in the Table: https://airtable.com/api
+1Did you do a ctrl+find in the browser to see if there is a match for the field name?
Fields show up in the order in which they were added to the Airtable Table.
Check the Airtable API to make sure the field appears in the Table: https://airtable.com/api
Ok ill figure out finding that field later, I ended up just creating a new test table to see if I could get this time added into the field. So the onfleet data in comes as UNIX, which I assume I need to convert maybe? Anyways I tried converting it and its not posting into the airtable. Here are the steps of whats happening
On step 4 notice that it doesn’t even attempt to add the date...Any thoughts? Btw, you have commented on a few of my posts...thank you very much for your help I appreciate it!
+1Oh I figured it out, I needed to format the date into the one that has the T in between it because that's what airtable accepts. Thanks!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
