I have to create 100 pages whose name i have in excel, can I have a workaround to convert those name to coda pages and subpages. The opposite is possible, I have converted all the pages using coda api and google app script to convert to google sheet.
Thank you in advance.
Do they HAVE to be pages?
How about making them cells in a canvas column?
P
Is this a one-shot conversion or an ongoing workflow?
If it is a one-shot conversion, …
-
Copy/paste the names from Excel to a new table in Coda.
-
Create a page in the same doc as a template for the new pages to be created.
-
Create a button that loops through all the records in the table of names and uses the “Duplicate Page” action to duplicate the template page, setting the name and parent page in the process.
-
Press the button!
Depending on how you want to set up parent pages, you may need to adjust this workflow, but this should give you a start.
If you want an ongoing conversion, you can still use the Duplicate Page action, but you will need to add a bit more logic to keep track of when and which pages to create.
2 Likes
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.