Oct 01, 2020 06:43 AM
Hello, I receive time data in UNIX format in a text field on airtable. I would like to create a formula that allows me to have a date that I can understand, in the same basic format already on airtable. Could you help me? Thank you in advance
I’m living in Switzerland, Zurich time
Oct 01, 2020 06:58 AM
You would probably want to use the DATETIME_PARSE function, which is described on this page:
Oct 01, 2020 07:25 AM
Thank you I think I managed to convert. Now the problem is that I have 2 fields with dates, I would like to have only one date field, in which it automatically converts the UNIX time and also in which I can manually add a date. Is this possible? If yes, how can I do it?
Oct 01, 2020 11:58 AM
I’m not sure I completely understand what you’re trying to do. Would you like to upload some screenshots to illustrate?
You are correct that you can’t modify the results of a formula field — you can only modify date & time fields, and then you could have a formula field result in a certain date & time based on the other fields.
Oct 01, 2020 01:29 PM
It looks like you will need three fields.
Having all of those fields when you really only want one is annoying, but there isn’t much help for it. You can hide the extra fields in views where you do not need them.
Oct 01, 2020 08:18 PM
Yep, this is presently not possible in Airtable as @kuovonne indicates.
@Taylor_Savage - this is precisely why regular fields should also support formulas as I have mentioned a number of times. Creating multiple fields to shape the data the way it needs to be presented is often seen as kludgey by users. This is what I proposed many months ago when we encountered a financial issue where a formula field was repeatedly calculating the lat/lng through a service that created unnecessary fees.
As shown in the diagram the Formula Field was constantly running the geo-compute process without knowing that it had already run (many times before). Formulas cannot introspect themselves and because of this, they cannot be smart enough to not recalculate.
If a regular field could also support formulas, it could [smartly] inspect its value and take actions that override the field’s value.