Hi! I am using Airtable to create an inventory of items in a museum of education related items. The vast majority of the items in our collection only have a year attributed to the item (i.e. class of '89, picture taken 1976, Spring 1935, etc). I am w...
Hello,I manage an Airtable base for a motorsport event management company. Right now, we have to use JOTFORM for the customer registrations, because the company uses Authorize.net, and the client wants the registration form to be submitted with payme...
Hi everyone,I'm new to the airtable world and I would like to understand if there is a way to synchronize the field of a base with the field of a different base.Any advice is welcome, thanks!
Is there a way to mirror information from a lookup field into an adjacent long text field? I'm using Diagram Automator and the "insert image" function can't read/populate a URL from lookup field only a text field.Maybe a formula or script that could ...
Hi, I'm trying to set up a filter to target certain records, but it appears like they are not filtering as they should.So basically I'm trying to exclude records that contain certain words in a field, but they still show up, as you'll see in the atta...
We use QR codes and print labels using the QR codes. However, Make cannot access the QR code anymore due to the URL's no longer working. This happened once last week, and then was resolved. Is anyone else experiencing this?We rely on the QR code U...
Hi, I have some data I have collected from 2 separate clients I have done work with throughout the past couple of years. Is it possible to create 2 separate tables that pull the information from the original created table and separate them into the ...
Hello community,what do I wrong? I have a field with #Numbers f.e. 80 or 80,1In another field I try to format this field to a url format, that means I would like to replace the , with an -.For this I use the Substitute formula:SUBSTITUTE({Numbers}, ...
It is not about Formulas, but Form was not an option for a label.I need to put a form, where I let people to pick a product. I want to create a dropdown menu to select product. After submitting I need to remove that product from options. So there is ...
Any Idea why the scripting block would give me this error? I've seen let query = await table.selectRecordsAsync();used in other scripts.
I've come across a strange issue.Using MAKE (aka Integromat) I'm using an Airtable Search Records module with the following formula:AND(Lower({Email (from Members)}) = "{{lower(2.`recipient email`)}}", {Order Number} = "{{51.`$1`}}")It accepts it but...
Hi there, I am brand new and been reviewing all the support docs but cant quite figure this one out. I want to create a list of tasks that will always be the same, and will populate based on the type of field. For example, I am using airtable with ...
Hi The screen shot is of a table for sales in one of my bases. The 'pay window filter' field determines which pay month the date falls in, our pay windows run 25th to 24th, so 26th September would fall in Oct Pay Month. The 'Pay Month' Field formats ...
I've set up an interface dashboard that pulls in data from two different tables. Within this dashboard are two number elements that are Field summery Sums of data from the two tables. In a third Number element I wanted to use a formula to divide one ...
Total airtable newbie here in need of some help and direction, please! I have two tasks I would like to accomplishPlease find below a screenshot of what my table looks like. I have a drop-down selection field for each year camp has taken place, and c...
Hi, I’m trying to find a way of calculating the difference between two values within the same field but in different records within the same table as per the image below. I have read many similar questions and answers but they always appear to be ove...
Hi all, any help appreciated.I'm creating a Matrix and trying to use the bulletpoint "Unordered List" and check box style "Task List" options when creating the content. I am copy/pasting the syntax directly from the Markdown cheat sheet and it is wor...
Hello all! I'm using airtable for my inventory management system. I'm using a bar code extension, and it needs a field to generate barcodes from that will be either 12 or 13 digits. I already have a field that has just started from one and numbere...
I got 3 tables:Trainings Lecturers Matching tableAs you can see on table Lectures i started matching Lectures with Trainings one-by-one. But the list is very long. Do you have any idea how to match Lecturers with trainings on one table?
Hi - I have a field labeled "reporter." It allows me to choose and select from a dropdown list of all the reporters that have been entered into our system. Is there any way to manually add someone into a cell in this column who is not on our list of...
