Skip to main content

I 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?

Try the button at the bottom

 


Try the button at the bottom

 

No dice I had tried that :/ 


Did 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

 


Did 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!


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!