Quickly delete Sheet Summary

HI there!

I think that I already know the answer to my question but I am hoping that the Community will tell me that I am wrong 😊

Is there a way to quickly delete ALL of the fields in a Sheet Summary without having to select the kebab and the scroll down to "Delete Field" for each individual entry?

Here's where I am at: I have 84 sheets. These sheets were created from a template that, itself, was created using another sheet (think of it as a sort of version 2.0). However…unbeknownst to the creator, that source sheet contained the maximum allowable fields (200?) in its Sheet Summary…😮

Now I find myself having to delete the "old" Sheet Summary fields 1…..at….a….time….

That's about 17,000 fields. I am looking for a sort of magical "NUKE" button that will allow me to go into a summary and wipe out all of the fields in one go.

I know….wishful thinking. PLEASE tell me that such a feature exists and that I have simply overlooked it 😁

Thanks!

Find more posts tagged with

Sheets

Sheet Summary

Accepted answers

Paul Newcome

You will need to leverage the API, the premium add-on Bridge, or some other similar third party app.

All comments

Paul Newcome

You will need to leverage the API, the premium add-on Bridge, or some other similar third party app.

Kyle Morgan

Thanks, Paul! Any suggestions as to how I could utilize Bridge?

I appreciate you pointing me in that direction.

Paul Newcome

It would still be API modules and probably a JavaScript module.

API module to get a list of the sheet summary fields.

JS module to create the url to delete.

API module to delete.

This will manage one sheet at a time. If you move all of the sheets to a single workspace temporarily and only those sheet you want fields deleted from, you can start by getting the workspace children (api module) to get the list of sheets as runtime data then pass that to a child workflow that uses the above to delete the fields. That would allow you to hit the "start" button once and loop through all of those sheets.

Kyle Morgan

Thank you!

I appreciate the help and the clarification. I should be able to give this a shot in the next day or two.👍️

Paul Newcome

Feel free to revisit if you need help getting it set up. My instructions were pretty high-level, so if more detail is needed, just let me know.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.