Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Newbie question, date

834 0
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I am sure it is quite simple, but for some reason, I can't find the way to do it.

Let us say I have Table A. In the Table A, I have, amongst many others, a Date field.

I also have Table B, with two fields in it. One field is a (unique) Date. The other field is just a number. Let us call it [Day Number].

[Table A/Date] and [Table B/Date] are not linked.

I just want [Table A] to look at its own [Date] field, then search for the corresponding [Date] in [Table B] and retrieve the corresponding [Day Number].

Must not be very difficult, but I can't find the way!


3 Replies 3

No, that is not possible in Airtable unless you link the records, or write an automation to do it for you. You can write an automation by using Airtable's native automations or by using Make.

11 - Venus
11 - Venus

Here is an example of using automation.
Airtable - Date Matching
Copy this base and add the following automation

2023-09-08 102459.png

In automation, Dynamic values cannot be used for date types, so they need to be formatted into a date string for comparison.

Be careful, the Free plan allows only 100 automation runs.

6 - Interface Innovator
6 - Interface Innovator

Great, I'll try that for sure, looks exactly what I need.