The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Is anybody else having a problem with the filter conditions on the Record Review record list? It is not filtering correctly according to conditions. I am sure it was last week and I haven’t changed anything. I feel like I’m going mad.
Set up the Record Picker with a filter that is controlled by elements on the Interface.
For example, I am setting up a content approval Interface so that the user can see all of the records that need approving in the Record Picker. The Record Picker ...
I’m imagining being able to access the data in a linked record in a similar way to how you access child properties of objects in many programming languages.ExampleYou have an ORDERS table and a PRODUCTS table. PRODUCTS contains Item Name, Item Code a...
We have multiple users working on our Base at the same time. Because any changes to a Table View persist across all users, we have to have personalised Table Views for each user. Otherwise users clash with each other when editing a particular Table V...
You are thinking of Airtable as a spreadsheet rather than a database. It wouldn't make sense to sum all of the durations in the same table. Generally when groups of some quantity (or duration in your case) need to be summed, you would have a 2nd sepa...
60*60*HOUR({timeIn}) + 60*MINUTE({timeIn}) + SECOND({timeIn})This will give you the number of seconds into the day. Make a similar calculation for 6pm and then compare them.
You should definitely do it the third table way. If you ever find yourself having to add fields to a table that are specific to a record in another table, then you've probably got your structure wrong.
I'm not sure what can have gone wrong there but it seems to be subtracting 1 day instead. Try using an intermediary Duration formula field:{TD Work Days...} - 1That should equal 8 for the examples you have posted. Then do the DATEADD formula using th...