Column order in App + extra column in google sheets

[Filip_Kosciuk]

Hello

1. question:
   I would like to change column order in my invetory app but I do not have any idea how can I do it.
   For example I want “current stock” at the top of the each product page but I do not know how to move it up.
   
   

2.question
I want to add new “current stock” column in Google Sheets. How can I do it? I just want to import data from this column into Google Sheet.“current stock” has already a formula and some number values in my app.
I tried to add extra column in Google Sheet and then regenerate structure via app in columns but “current stock” has completely disappeared from my application.

3.why some columns are blue and some are have regular grey color. what is the difference?

thanks for your help

[Koichi_Tsuji]

No. 1 == Create a slice out of your table and use that slice for your views. On slice you can reorder the sequence of the column to appear. Or you just go to the view setting and change the column order from there.

No. 2 == Current Stock is virtual column. Not existing. If you want to save the type of fields to Physical one rather than virtual column to keep the recording the value into the sheet. But there is downside of it. Unless you go to edit mode of each column, the value of the field will not be update.

If you want to capture the VC data to spreadsheet, i would suggest you put the action to download the table data to CSV.

No.3 == Blue indicates it is virtual column, not physically exist. Read this.

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Steve]

Filip_Kosciuk:

I would like to change column order in my invetory app but I do not have any idea how can I do it.

tsuji_koichi:

Or you just go to the view setting and change the column order from there.

[Filip_Kosciuk]

I do not want to change column order on the product list which I can do in UX/Views/Column Order.
I want to change column order on the Product Page.
I was trying to do it via Slices and I move Current Stock right after picture but it does not work.

How can I transform this virtual column into physical column?
I was trying to create new column “Available” from Google Sheets, then I used same formula as “Current Stock” but it doesn’t work correctly (did not add new stock for example).

[Steve]

This appears to be a detail view:

If you already have the detail view columns configured, it will override the slice column order.

Whether you have a column order set in the detail view or not, in a detail view, if a column value is blank, the column will not be displayed unless you take steps to force it.

That the column isn’t shown suggests either the column value for that row is blank, or the view is not configured to show the column.