The Scenario
You're a product manager. Your team uses NocoDB as a project tracker, and there's a 'Public Roadmap' view that external stakeholders can access. Someone on the engineering side added 15 new internal columns last sprint — columns that absolutely should not be visible in the public view. You have a Google Sheet with 25 column IDs and a hide/show flag next to each one. The ask came in this morning. The stakeholder meeting is this afternoon.
The bad version:
- Open NocoDB, navigate to the 'Public Roadmap' view, open the Fields sidebar.
- Find the first column that needs to be hidden, toggle it off.
- Find the second one. Toggle it off.
- Repeat for all 25 columns — while keeping the sheet open in a second tab to track which ones you've already done.
You're a product manager. Your job this afternoon is to present the roadmap, not to spend the hour before it clicking toggles in a UI.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads your column ID and flag data and through its NocoDB integration can apply the visibility settings to the specified view — all 25 columns in one instruction.
Column A has NocoDB column IDs and column B has 'hide' or 'show' — update the visibility of each column in the 'Public Roadmap' view in my NocoDB base accordingly
What You Get
- Every row in the sheet is processed — column IDs matched to their NocoDB counterparts, visibility set to match the flag.
- Columns marked 'hide' are hidden from the 'Public Roadmap' view.
- Columns marked 'show' are made visible.
- Any column ID that can't be found in the view is flagged rather than silently skipped.
What If the Data Is Not Quite Ready
Some column IDs in the sheet don't exist in that view — they're from a different base
Column A has column IDs, column B has hide/show — update visibility in the 'Public Roadmap' view — for any ID that doesn't exist in that view, write 'NOT FOUND' in column C instead of failing the whole run
You want to confirm current visibility before applying changes
For each column ID in column A, check its current visibility in the 'Public Roadmap' view and write the current state ('hidden' or 'visible') into column C — then apply the hide/show flag from column B and write the updated state into column D
The same changes need to apply across two views
Column A has column IDs, column B has hide/show — apply the visibility settings to both the 'Public Roadmap' view and the 'Sprint Board' view in my NocoDB base
Full kill-chain: validate IDs, apply settings, confirm changes, flag any that failed
Column A has column IDs, column B has hide/show — validate each ID exists in the 'Public Roadmap' view first — apply the visibility change — write 'UPDATED' or 'ERROR: [reason]' into column C — write the total updated count into cell E1
One prompt covers the validation, the update, and the confirmation.
Try It
Get the 7-day free trial of SheetXAI and open the sheet with your column configuration flags before your next stakeholder meeting, then ask it to apply the NocoDB view settings in one shot. Also useful: Audit All NocoDB Integrations and Write Results Into a Google Sheet and the NocoDB integration overview.