Check out the created time field. Not sure what you mean by tabs - would groups be ok?
Check out the created time field. Not sure what you mean by tabs - would groups be ok?
I think she means that for each month there is a table and she wants a single form to target incoming updates into each monthly table dynamically.
This is not possible, of course, because forms are a function of tables; no form can populate data into any table except for which the form was created.
Architecturally, it’s generally not sound to divide data sets physically; much better to use logical assertions to create data sets such as monthly, yearly, daily, etc. I do believe there are good reasons to divide data sets to match other reporting and organisational requirements. A good example is data flowing in from different business units.
@Lost_Our_Home_Pet_Re, I recommend you create one form (as you suggest) and unify all data into a single table and then use other Airtable features (such as groups or views) to virtualize the different months.
Yes, by tabs we do mean tables. We do currently have it set up with the created time field. I will just have to instruct the daily users to filter by that field when looking for specific months of data. Thank you!
Yes, by tabs we do mean tables. We do currently have it set up with the created time field. I will just have to instruct the daily users to filter by that field when looking for specific months of data. Thank you!
You might want to consider adding a formula field that looks at the created time field and converts it to a month. For example if you named the created time field ‘Created Time,’ this is how you would get the month number:
MONTH({Created Time})
Month words wouldn’t be too complicated of a formula to write either.
Once you have a month column, you could create 12 views, each filtered to a month. Or you could have a master overview that shows all the months, but the data is grouped by month.