Q: Graph and table displayed from google sheet data
Can ColumnsAi work in this case below:
A building has 10 rooms (10 diff managers)
Each room has 20 equipments (1 mngr to record daily reading of the 20 equipmnts)
That means there are totals of 10 rooms x 20 equipments = 200 equipments
Each manager has their own login details to record daily reading of 20 equipments .
That means, everyday, 10 managers will fill in 10 forms (1 form for each room).
Then after they fill in the forms, all the data (reading) will automatically be shown (displayed) into the website , so that all people (public) can see the reading and data.
Public people can choose which room and which equipment reading to read.
Can ColumnsAi do all above? If not, which part of the above can ColumnsAi do?
Does ColumnsAi display all the data (from the forms) inserted by the manager?

ShawnCao
Jul 21, 2025A: As long as you use the same form to let all managers submit the answers, it should go to the same spreadsheet which you can link in Columns as a data source, then graphs built from this data source can be pivoted or filtered by those fields easily.

Verified purchaser
Nice