There is no column correspondence between the google sheets tables, the emulator and the deck view, how can I solve it?

[Jorge1]

There is no column correspondence between the google sheets tables, the emulator and the deck view, how can I solve it?

[Aurelien]

Hi @Jorge

Welcome to the community.

Various possibilities:

• hard way: regenerate structure
• soft way: change manually all column names in the editor, then when it matches the google sheets column headers, regenerate columns for the remaining columns
  
  

About the emulator: I suspect you are relying on “display name” rather than “column name”.

[Jorge1]

What I want to link in my “Customers” table is the customer with his address, which is in the same table …

[Jorge1]

Muchas gracias!

[Aurelien]

Jorge:

Muchas gracias!

Hi @Jorge

Jorge:

What I want to link in my “Customers” table is the customer with his address, which is in the same table

I don’t get it. This is not the question from the initial post ?

[Jorge1]

Perdón por confundirte, ya resolví el primer tema.
El que no he resuelto es el de vincular dos columnas de la misma tabla, por ej, el nombre del cliente con su dirección, quiero que cuando elijas el nombre del cliente se rellenen automáticamente su dirección, su teléfono, etc.

Gracias por el apoyo!

[Aurelien]

Alright then,

I suggest you have a look on this post:

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

You may want to use this kind of expression in the Initial value field of each column:

[yourClient].[Address]
[yourClient].[Phone]

and so on.