Skip to main content

Can you create new views via script?


I did some searching but wanted to be certain since I’m still relatively new to the scripting block.


Does anyone know if there is a way to create new views?


My use case is that I currently manually create a suite of views each time I add a new client and/or project. For every project I will have an All view that shows everything about it, then an Open view that only shows stuff that’s currently being worked on, an Invoice view that gives me a summary of the tasks that need to be invoiced to make my invoicing faster, etc.


Currently I have template views that I duplicate and update the related filters to have it show the right records. I’d love to automate this with the scripting block, but I don’t see a way to create new views from script.


Am I missing something? Anyone else have any ideas?


Thanks!

29 replies

  • Known Participant
  • 28 replies
  • February 23, 2020

I think the only think you can create is records.


  • Inspiring
  • 251 replies
  • February 24, 2020

Hello,


I got the same questions, and a little more:



  • what you just asked ;

  • how to programmatically (by Script Block) do what we can do while creating or modifying one table from UI:



  • add FIELD ;

  • modify FIELD type & its format ;

  • move FIELD between other FIELDS ;

  • rename FIELD ;

  • delete FIELD ;

  • create / modify Linked FIELD ;

  • create / modify LOOKUP FIELD ;

  • create / modify FORMULA ;

    …/…

    because I’m creating my own TABLE Templates

    then I would programmatically (by Script Block) rename, copy and/or move it into its BASE then Create-Read-Modify-Write-Move FIELDs as I just wrote.


@Kasra @Dru_Knox @Stephen_Suen


Best,


olπ


  • Inspiring
  • 79 replies
  • February 24, 2020

At this time, you cannot programmatically create or modify tables, views, or fields via the scripting block. You’ll have to manually perform those actions in the main table UI.


  • Author
  • New Participant
  • 4 replies
  • February 25, 2020
Stephen_Suen wrote:

At this time, you cannot programmatically create or modify tables, views, or fields via the scripting block. You’ll have to manually perform those actions in the main table UI.


Thanks, Stephen (and all).


Humbly requesting this feature 🙏


  • Inspiring
  • 251 replies
  • February 25, 2020

Thanks, Ariel and Stephen

So do I 🙏


I can see this being very useful too - one example being to give subcontractors their own read-only view of work assigned to them without having to set them up manually.


  • Inspiring
  • 251 replies
  • February 26, 2020
Stephen_Suen wrote:

At this time, you cannot programmatically create or modify tables, views, or fields via the scripting block. You’ll have to manually perform those actions in the main table UI.



Thank you @Stephen_Suen & Script-Block team !

I hope these instructions will be added in a future evolution of Script-Block, in a not too distant future, because I’m tired of cloning my tables-templates by adapting Field-Names and Field-Types and Views by hand.

Thank you for your understanding,

olπ


Russell_Bishop1

Automating creating Views, Dashboards… that would be a dream.


At the moment I have to do this manually and it takes ages…



  1. New Project

  2. Create 3 new Views – Add Filters (manually paste name of linked record)

  3. Create Dashboard

  4. Duplicate Blocks from existing Dashboard

  5. Change all Blocks to use new Views


Please help me 🙏


  • New Participant
  • 1 reply
  • September 8, 2020

Any updates on this?


Would love to have this option or even a block that can create multiple views.


  • Inspiring
  • 251 replies
  • September 8, 2020

hi @nino_regala,


Not (yet) a Programmatic Views Manager by Airtable,

but I could hope both these posts will help:






Not yet tried: I’ve first to play with REACT.js and that’s what I’m doing now.


olπ


  • Known Participant
  • 17 replies
  • October 1, 2020
Olpy_Acaflo wrote:

hi @nino_regala,


Not (yet) a Programmatic Views Manager by Airtable,

but I could hope both these posts will help:






Not yet tried: I’ve first to play with REACT.js and that’s what I’m doing now.


olπ


Hey this great!,

is views.create / update / delete in the pipeline or in the making?

Many are looking forward to have this option - as it will be HUGE.

Thanks,

Onur


  • Inspiring
  • 251 replies
  • October 1, 2020

Yes, I’m thinking it’s HUGE too

and some workaround I had considered by use of



doesn’t seems to help because Fields Props (field.description eg.) seem to stay Read-Only against any request and expectation…


oLπ


  • Participating Frequently
  • 14 replies
  • January 8, 2021

This will be an awesome feature. Creating (and deleting and updating) tables, views and fields wold be a big game change.

Will give the opportuinty to programers to manage airtable in a more automated way.


One use case I wanted to do searching for this feature is to create a table to manage views and fields. I have a CRM with a lot of data, and a big headache is the management of a lot of fields and views with other team members if this part could be automated via this feature would be a big step on custom app creation via airtable.

In my case I wanted to create groups of data in a new table, so each group of data has it’s configuration, table relation and fields, so with automations would be able to create a self organizing groups of fields for my CRM.


  • New Participant
  • 3 replies
  • July 25, 2021

Any update on this feature?


This will be game changer!


  • New Participant
  • 3 replies
  • October 4, 2021

I would like this feature also 🙏


  • New Participant
  • 2 replies
  • October 12, 2021

Would love this too!


Any news on this? 🙂


  • Participating Frequently
  • 6 replies
  • November 23, 2021

is views.create / update / delete in the pipeline or in the making?


@Airtable teams, could you tell us about this feature indeed?


It would be super useful: the use case I’m stuck with is the dynamic creation of forms (generating forms with questions/descriptions based on input data). Well, ideally I would have like to use dynamic forms to deal with it, but since it doesn’t seem to be in the roadmap I was thinking of using a script to duplicate a template form and update some questions/descriptions to make that work.


Thank you for your help on this, and for this wonderful product!

Ludo


  • Inspiring
  • 118 replies
  • November 23, 2021

Yes I need it too. At least allow us to create view based on automation.


E.g. when it is the first day of the month, new view for that month will be created.


Thanks!


  • Inspiring
  • 251 replies
  • November 23, 2021

Hi,


Yes, this is still relevant because the new INTERFACES are not Scriptable (for the present) nor Shareable like the Views are (for the present).


olπ


I was hoping to hear that this was possible, but sad to hear it isn’t. Perhaps I can get by with creating new tables. :crossed_fingers:


Would love a feature to create new views via script blocks.


  • New Participant
  • 1 reply
  • April 25, 2022
Stephen_Suen wrote:

At this time, you cannot programmatically create or modify tables, views, or fields via the scripting block. You’ll have to manually perform those actions in the main table UI.


Hi Stephen, I am also currently looking at this feature and would love to see something allowing these actions!!! I love Airtables I am forever recommending the platform to friends in my profession and this would only enrich the experience further:)

Kind regards,

Jordan


  • New Participant
  • 4 replies
  • June 21, 2022

any update on this?! 🙏


  • New Participant
  • 1 reply
  • July 28, 2022

Are there any changes on this issue?

really need this


  • Known Participant
  • 14 replies
  • August 17, 2022

I hope this will be added after ability to create Tables and Fields was added

+100 for View creating/updating feature!!


Reply