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