The views here needs to be changed but instead of doing it manually because there are a lot of them, I want you to create a tool where:
-
I can specify a column title, the new column title, and a new column formula
-
The tool will go through the views of a database find the specified column title (ignore columns that have no column title), change it to the new column title and change the column formula to the new column formula
-
If the new column title is specified but not a new column formula, then only the column title is changed
-
If the new column formula is specified but not a new column title, then only the column formula is changed
-
I also want to be able to specify a column title, click a button, and the tool will show the formula for that column. This is so I can find out if a particular column’s formula is consistent all throughout the database.
This is Urgent.