Relationship and References Created in Glideapp Table

Ask for Help
1

Dear Glide Community,

We have created a Glide Page using the data tables from Glideapp.

not shared
not shared1108Ă—486 22.1 KB

We found that Relationship and References Created in Glideapp Table are not seen or accessible in Glde Page! Do we have to redo all the required in Glide Page again?

1662960790091
1662960790091872Ă—787 118 KB

Thanks in advance.

2

Do you create the Pages Project from scratch, or did you use the “New Page from data” option?

new-page-from-data

If you choose “New page from data”, you should get a full copy of the database, including all computed columns. Note however that is a one time thing. Computed columns are never synced between projects. So once you start changing them or adding new ones, the computed columns in each project will diverge.

3

Got it

Thanks

4

Hi Darren @Darren_Murphy Does it mean if the Glide Tables on different app does not share the same external DB, any updates on the data will be be sync between the 2 apps.

Which means if Glide page is used to support the Glideapps, external DB will be required.

5

The way your question is posed is a little confusing, so I won’t try and answer it directly. Instead I’ll explain how it works, and maybe that will help.

First thing is that it’s important to understand the difference between Basic and Computed columns. Maybe you already do, but it’s vital in this context so I’ll explain it anyway.

  • Basic Columns are those columns that contain actual data, as opposed to data that’s calculated from other columns. Text, Email, Image, Date/time are all examples of Basic columns. Note: If you have columns in a connected Google Sheet that contain formulas, these are also considered Basic columns. Glide has no idea that your spreadsheet contains formulas - it only sees the resultant values.
  • Computed Columns are columns where the values are calculated based on the values in other columns. Math columns, relations, rollups, single values are all examples of computed columns. All of the Glide plugin columns are computed columns.

Now, when you choose the “New Page from data” option, Glide will immediately present you with a second choice to make:

  • Keep same sheet
  • Copy the sheet

Which of those you choose is important, because it will affect what happens moving forwards in terms of data and column sync between the original App and the new Pages project.

  • If you choose to “Keep same sheet”
    – Your Pages project will now be connected to the same database, including Basic columns and Computed columns
    – If your App was connected to a Google Spreadsheet, your Pages project will now be connected to the same Google Spreadsheet.
    – Any native Glide tables that you had in your App will now be shared Glide tables - shared between both projects
    – If you change a value in a Basic column in either project, the change will appear in the other
    – If you add/remove/reconfigure a Basic column in one project, the change will appear in the other
    – BUT… Computed Columns will not be kept in sync between the two projects. Initially they will be the same, but that’s it. If you make a change to a computed column in one, the change takes effect ONLY in that project. You won’t see it in the other.

  • If you choose to “Copy the sheet”
    – Your Pages project will get a full copy of the database, including Basic and Computed columns
    – If your App was connected to a Google Spreadsheet, your Pages project will now be connected to a COPY of that Google Spreadsheet.
    – There will be no linkage at all between the two projects. Any changes that you make in either will have no effect on the other.

6 Likes
6

Got It! Thanks and appreciate!

7

Just to be clear - if you have V1.0 and spin off V1.1 and you make a change to a Computed Column (template column, query,etc) in V1.0 it will not be visible in V1.1 (and vice-versa) so you have to manually ensure change control for Computed Columns are tracked if your want to ensure that Apps are in-sync.

Same with Layout changes (but that one seems more intuitive.)

Also, changes to Google sheets Basic data will be visible between V1.0 and V1.1 (and vice-versa). WiIl Glide Basic data columns maintain synchronicity between V1.0 and V1.1 (and vice-versa)?

Thanks as always

8

If it is a single shared table, then yes. Even user specific values will sync across Apps, which can cause some unexpected behaviour :slight_smile:

1 Like