Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 07, 2023 03:15 PM
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!
Sep 07, 2023 04:45 PM
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.
Sep 07, 2023 06:47 PM
Here is an example of using automation.
Airtable - Date Matching
Copy this base and add the following automation
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.
Sep 08, 2023 05:16 AM
Great, I'll try that for sure, looks exactly what I need.