Hi,
Can I rename the tab "page1" in this appsheet form with tab
without having to make a new column in the main google sheet database and make it as show type.
Solved! Go to Solution.
I understood perfectly your post.
I am explaining that in order to even have the tab named "Page 1" there will be a Show column in the table for that tab which you can change - whether it was auto-generated or created by you. Find it and simply change the Content proerpty text "Page 1" to what ever you wish.
Let me explain.
Years ago the approach to creating a tabbed view was to insert columns into the sheet named "Page_Header:<<tab name>>", where <<tab name>> was some text you gave. You placed these columns strategically in the sheet where you wanted tabs to appear and as assignment of the columns to the tabs. See image.
Sheet with Tabs specified
AppSheet automatically creates these "Page_Header" columns as Show columns in the app using the sheet column name as the table column name. AppSheet also assigns the Category property as "Page Header" and extracts the <<tab name>> portion to assign to the Content property. See images.
Sheet column assigned to AppSheet table column
Page_Header column automatically set as a Show column in the table
Today, we can control the placement of these Show columns BUT we still must place them at the start of each tab. this column order can be determined by the view definition itself or by the order of columns in the table or slice used as the datasource for that view.
In the image below, I am showing a view in my app with tabs. The view is sourced from a slice and does not specify ANY column order. The column order is determined by the Slice. In the Slice, the first column is "Page_Header:Demogrpahics" which assigns the first tab. BUT the tab name doesn't come from the column name. It is determined by what is set as the Content property inside the column definition. See images.
Example using Page_Header column in a Slice. Slice determines column order and tabs
Same tab column with the Content property changed
I hope this helps!
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |