Hi all, I am trying to create an automation such that when a person creates a new record in the projects table, a view is automatically created in the tasks table such that any records with that record are filtered to be the only records shown. I figured that this could be done with scripting, but I’m not sure how to create a view in the tasks table with a specific filter applied.
Solved
Trying to create new view with certain filter applied
Best answer by ScottWorld
That is not possible with Airtable. Views and filters cannot be changed via scripting nor the API. Views and filters can only be changed manually by a user on their device.
You may want to change the filter to only show the user their own records, and then sort the records so the newest one is at the top. Then, the user will always see their new record at the top of the view.
If you do this at the data layer, you’ll need to create a separate view for each user.
If you do this at the interface layer, you only need to create one interface page because interface pages can dynamically change to show the currently logged-in user their own records.
Because of this and all the other advantages that come with interfaces, interface pages are vastly superior to data layer views.
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+35That is not possible with Airtable. Views and filters cannot be changed via scripting nor the API. Views and filters can only be changed manually by a user on their device.
You may want to change the filter to only show the user their own records, and then sort the records so the newest one is at the top. Then, the user will always see their new record at the top of the view.
If you do this at the data layer, you’ll need to create a separate view for each user.
If you do this at the interface layer, you only need to create one interface page because interface pages can dynamically change to show the currently logged-in user their own records.
Because of this and all the other advantages that come with interfaces, interface pages are vastly superior to data layer views.
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+28Hey
What data do you need to see from such tasks? Just the name? Additional detail information from such tasks?
I had a similar need last week. For every Project, I needed a specific Tasks view created. Views on the data layer cannot be automatically generated. Pages on interfaces cannot be automatically generated. Either way, even if I would be able to do that that would lead to hundreds of views and pages created (I don’t think there is a limit on views, but there probably is on pages). I would NOT want so many views or pages.
Furthermore, I really needed end-users to be able to update records. (i) would be super costly paying for such seats, (ii) would require login, (iii) if done via fillout forms, user experience was far from ideal (clicking into a record on the parent form which would in tun open the child form, and that should be done for each task update).
So…………………. I thought I could give Zite (product form the Fillout guys) a second chance (first time I used it I was not impressed). Turned out GREAT. In fact I’ll be recording a video on this matter soon.
I connected the corresponding AT base to it, and my first prompt was:
“Please generate a very minamalistic app that will have a grid view of records from the Tasks table, showing the following fields: X, Y, Z. The page should be constructed using a record id of a linked record on the Project field. So the grid will only show records of the Tasks table which are linked to the Projects table through the Project field. Meaning that this will be dynamically generated. Make sure that the end user can make changes on the cells of the grid. Page should include a Save button. Upon clicking on it, values for changed cells on Airtable should get updated in bulk. Allow for CSV download only when all changes are saved. Make sure the UX is similar to that of a spreadsheet, where user can move around using keyboard arrows. Single select fields should include options from Airtable dropdowns. X field should NOT be editable. Include a search bar, sorting, and filters.”
GREAT result. I’m actually really excited about this. This does not require login, so it is pretty lean (not to be used for super confidential info). The url gets automatically generated as it uses Project record id (you’ll want to have a formula for its consturction on your Projects table). This url can be emailed to whom it may concern.
Hope this helps!!!!!!!
+28
I’m pretty sure API does not allow for dynamically/automatically creating views (you can check Airtable’s API documentation here). Answer above seems to be wrong and completley AI written.
If I’m missing smth, I’d love to create views via api.
Mike, Consultant @ Automatic Nation
YouTube Channel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.