I have master blocks of code in my code table.in another table - main table -I wish to get data from a field in the code table by specifying it’s rec ID. I will then combine this code with other data from the main table. I can do this with a linked t...
I am trying to create a project tracker with a task list and start dates and end dates for each task that are calculated automatically based on a dependent (linked) task and its associated dates. My problem is how to create the first row because no m...
Hi,I'm in the unfortunate situation that I seem to have an automation bug that creates unwanted changes to some records, but not all.Since I cannot on my own find out which automation causes this (mailed support regarding this), I wanted to at least ...
Hello,Using a last modified field type named "Closed" and a lookup field showing the last one called "Meter Type" and "Repeat Interval" I am trying to calculate and output the appropriate date when closed is 7/17/2024 16:41, meter type is Calendar Mo...
New to all of this. No coding background; small business owner. I am trying to create a rudimentary inventory system with Airtable. I can't figure out how to get a formula to "count" the number of array entries in a linked record field, and return ba...
I have been reading for hours through the help forum and documentation, but ARRAYSLICE doesn't want to work for me.I want to achieve the following: Show me the first value of an array. My formula is: ARRAYSLICE(verticals_from_contact, 1, 1) but it do...
I have four (4) columns that are number data fields titled {Trip 1 Miles}, {Trip 2 Miles}, {Trip 3 Miles}, and {Trip 4 Miles}. The settings to the number data fields include decimal places and a screenshot of the settings are attached.Column five (5)...
I working on a formula that will provide me with 4 different outcomes depending on a products Variance from our target cost of product/FOB. Any products that have a variance less than -5% need to output "Red -5% or More Variance", products with a var...
I've searched on the community for solutions to combining one field that contains a date and another field with a duration to create a datetime field, but haven't come across any solutions to solve it. I'm using the DATEADD() formula but Airtable is ...
Hi everyone!I created a base for employees in our company with the table where are all information about every employee. I also created a form to update those information if necessary. I prefill all the fields and create a button field so that i can ...
