Hi guys, I am using a concancente function along with autonumber to get something like this X-2022-1 as a unique reference field for a record.However, I am wondering how we can do something similar (sequential numbering) that loops back to 1 at cert...
Anybody know a way to create proper request codes / references for each row.
For example, my current system is to concantenate a Letter (‘S’ for example) with the product name, then place the year of the request, then add the autonumber ID f...
I have landline and mobile numbers in my data base. If one of them is missing, i want to show the other, if both are missing, i want to keep it blank, and if both are full i want to concantenate them. This is my formula syntax but its not working...
Airtable seems to only offer a lookup for a specific string. I am trying to do a lookup based on another cell’s value.
Company receives a request for one table. In turn, it needs to make a request for quotation from 3 companies for wood....
I think you’re on to something here. Can you further illustrate how to it can work.
I’m trying to do something similar. I want to create a lookup for the contacts of a certain vendor, but only the contacts of a certain department,
I actually have an additional table for “vendor contacts”. My problem is the below
Vendor A only sells Apples, Oranges, and Bananas & employs John Smith
Vendor Contact John Smith only sells Apples and Oranges
I have a request for Appl...