Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Can I have Year (YYYY) ONLY be read as a date?

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...

Resolved! Mirror Lookup Field into a Long Text Field

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 ...

chrisberry by 5 - Automation Enthusiast
Solved
  • 385 Views
  • 3 replies
  • 1 kudos

Filters

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...

1.png
GB7 by 4 - Data Explorer
  • 472 Views
  • 1 replies
  • 0 kudos

HELP With Data Organizing

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 ...

Resolved! Formula show #ERROR! when Substitute from a Number Field

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}, ...

LastSamuraj by 4 - Data Explorer
Solved
  • 329 Views
  • 4 replies
  • 2 kudos

Forms - choice eliminator

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 ...

KuboS by 5 - Automation Enthusiast
  • 335 Views
  • 5 replies
  • 0 kudos

Scripting Error

Any Idea why the scripting block would give me this error?  I've seen let query = await table.selectRecordsAsync();used in other scripts.

Screenshot 2023-10-27 at 6.55.29 PM.png
chrisberry by 5 - Automation Enthusiast
  • 276 Views
  • 4 replies
  • 1 kudos

Resolved! MAKE Airtable Search Records Formula not retrieving Record

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...

GLS-74 by 5 - Automation Enthusiast
Solved
  • 305 Views
  • 4 replies
  • 1 kudos

Autofill field based on specific criteria

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 ...

MsRm by 4 - Data Explorer
  • 274 Views
  • 2 replies
  • 0 kudos

Resolved! Linked Records not filling down

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 ...

sehenley by 5 - Automation Enthusiast
Solved
  • 317 Views
  • 2 replies
  • 2 kudos

Resolved! Use formulas in an interface number elemtent

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 ...

sehenley by 5 - Automation Enthusiast
Solved
  • 452 Views
  • 3 replies
  • 2 kudos

Resolved! Calculate separate rows in same table

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...

IMG_0303.jpeg
Jezz by 4 - Data Explorer
Solved
  • 256 Views
  • 2 replies
  • 0 kudos

How to mach 2 tables using third one?

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?

Zrzut ekranu 2023-09-18 o 20.20.48.png Zrzut ekranu 2023-09-18 o 20.20.59.png Zrzut ekranu 2023-09-18 o 20.22.25.png
Maciej by 4 - Data Explorer
  • 357 Views
  • 1 replies
  • 0 kudos

How to manually enter a name in a field

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...

mgreen by 4 - Data Explorer
  • 215 Views
  • 1 replies
  • 0 kudos