When linking Google Form to Google Sheet , it will append data into Google Sheet and, thus the size will grow daily.\u000a\u000aQuestion. Can ColumnsAi extract only the latest data (today\u0027s data) from Google Sheet (and remove or ignore the previous data) and then show the data\u000a1. In table form format?\u000a2. In graph or diagram?

Linking Google Form to Google Sheet | Columns

Columns

Q: Linking Google Form to Google Sheet

When linking Google Form to Google Sheet , it will append data into Google Sheet and, thus the size will grow daily.

Question. Can ColumnsAi extract only the latest data (today's data) from Google Sheet (and remove or ignore the previous data) and then show the data
1. In table form format?
2. In graph or diagram?

ibestrikerPLUSJul 21, 2025

Helpful?

Related questions

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?
What are the team permissions?
Are there plans to add new features to this product? I want to use it more but it feels like LLMs can compete with this product with a single prompt
When embedding a chart on a page, there is a link that says -> view on columns, where the user can switch between the chart and the tables. The user can also download the data. Is it possible to remove this link when embedding a chart? It also allows anyone to just embed the chart without giving any proper rights to use the data. I'd ideally not want the data to be downloaded or have the user go to an external link. Is there a solution? Thanks

View product details

Columns

Share Columns

Related questions