I’ve seen one or two topics touching on this, hoping to see if there is a workaround here. Using DATETIME DIFF appears to be rounding down the resulting unit by default. For example, calculating the number of months between 1/1/2015 and 12/31/2015 re...
New Airtable user, I feel I am swiftly adapting to working in this environment. However, one issue I am having trouble visualizing is how to lay out a series of tables to meet this particular goal; any suggestions as to the most organized way to appr...
I am new to Airtable and haven’t had luck finding a solution for this use case. Is there a native or third-party function that automatically populates a Single-Select or Multi-Select field with the values from a column as selectable options? A manual...
Hey Adam, I can provide some basic information if it helps visualize:
The Billing Periods table contains one Autonumber RowID field (ie: “1”, “2”, etc.), a Billing Period Date field (ie: “1/1/2020”), and a Billing Period Pretty Name field (ie: “Janua...
Thank you for clarifying. I will take care to make this request, I’m sure the importance of this feature has been stressed by many users over the years.
After trying this suggestion, this does not appear to be the behavior I describe above, there may be a misunderstanding as to what is being asked (thank you for your patient responses). An example may be easier to follow:
Table A features a single “F...
I am happy to give this a try, entirely possible I am missing a common function.
To clarify:
Table A contains a “Fruit” field/column listing 50 fruit names (Apple, Orange, etc.).Table B is an empty table which will ideally contain a “Fruit Selection”...
Thank you for replying. I have read of this, though I don’t believe this is a solution as it is a one-time only, manual event. When the data in the original column is added to or changes, those changes would not be reflected in the drop-down options.
