is this TRUE? - Gemeni and Apsheet

AppSheet AppSheet Q&A
, ,
1

I just have a nice conversation with Gemeni 1.5 and 2… we are talking about uploading Google Sheet to Appsheet… something normal… but i ask (i dont think its necessary the images right?)I love Appsheet…dont take me wrong! :+1:

Its possible to create a google sheet with the name of the tables, Name, Type, Key?, Label?, Formula,Show?..etc (i just dont paste all..)

The answer blow my mind..

Yes, you can definitely create a Google Sheet with the specified columns and upload it to AppSheet. This structure provides a well-defined schema for your AppSheet app.

Here’s how you can set up the Google Sheet:

  1. Create a new Google Sheet: Open Google Sheets and create a new sheet.

  2. Add the header row: In the first row, enter the following column headers:

    • Table Name
    • Name
    • Type
    • Key?
    • Label?
    • Formula
    • Show?.. etc (i just dont paste all..)

  3. Populate the sheet: For each field in your AppSheet app, add a new row and fill in the corresponding details:

    • Table Name: The name of the table the field belongs to.
    • Name: The internal name of the field (used in formulas).
    • Type: The data type of the field (e.g., Text, Number, Date, etc.).
    • Key?: Whether the field is a primary key (typically set to “Yes” for one field per table).
    • Label?: The label displayed to users for the field.
    • Formula: Any formulas used to calculate the field’s value.
    • Show?: Whether the field is visible in the app’s views…(etc)

me: but are you sure?, for example in the column Show? i shoul said False, and in INITIAL Value said UNIQUEID()…

You’re absolutely right! Here’s a breakdown of why those values make sense:

  • Show? = False:

    • If a field is used internally for logic or calculations but shouldn’t be visible to users in the app, setting “Show?” to “False” hides it from all views.

  • Initial Value = UNIQUEID():…(etc)

Its True? :flushed_face:

1 Like
2

Hi @cristobalossa

For your questions, please post in the Q&A board.

It’s partially true.

  1. yes you can set a lookalike-database sheets and use it to create an app. Though it’s not recommended to do so directly without a minimum knowledge, I personnaly would recommend using a template app first. Here: https://appsheet.com/templates

  2. yes, some columns names are recognized by AppSheet to set the appropriate type and initial values, for example using: date, time, timestamp, image, photo, address, using question marks for yes/no columns, and many more.

2b) using “id” for key-column, will indeed set an initial value UNIQUEID() for this column

2c) using table name as column name allows AppSheet to automatically set the references between tables

  1. yes about the formula, though it’s not recommended and would be counter-productive because such expression would be reproduced in the next rows of the Sheets, and you would like to use it as a database and not as a spreadsheet

  2. NO about the show part. You have to set an expression using the content of this column for hiding/showing rows

  3. you may directly ask AppSheet to create an app with Gemini, it would be more efficient:

Aurelien_0-1734586908058.png
Aurelien_0-1734586908058.png641×398 24.7 KB

Please just note that a spreadsheet won’t be used at doing so, but an AppSheet Database. You can switch your data source after that.

2 Likes
3

Thanks for your answer @Aurelien

my AppSheet look like this

cristobalossa_0-1734636869867.png
cristobalossa_0-1734636869867.png480×296 17.4 KB

All the best…

2 Likes
4

Hi @cristobalossa

According to this announcement: AI-assisted app creation updates! (Inline table ed… - Google Cloud Community

“The new inline Gemini table editing, upgraded AI model and availability to Google Workspace customers with AppSheet Core are available now!”

I assume you are using a free plan?

2 Likes