Assuming I have the following form in one base:
And the following table in another base:
-
I want the entry in the zip to correspond to a table in another base meaning the zip entered should be in that table
-
The rate field in the form should autofill based on the date entered. For example, if a user makes an entry in the month of Feb, this “rate” field should autofill from “meal_feb” corresponding to the zip code the user has entered.
I am new to Airtable and I could really use some help.
Thank you.