Data view Help

zacc_oraro · 10-20-2021 06:15 PM

I have tables that are refercing to each other. Whe i fill out a form, that data in my google sheet shows id numbers instead of real values or text. This only happens to “ref” fields only.

Can one help?

Steve

zacc_oraro

I tried but, Im still getting the same results. As i have stated, all the fields are display well, but only the “Ref” fields are displaying id numbers in the data sheet. I using google sheet as my data source. I would like the “Ref” field to display the text selected from the enum value. Note, that my “ref” field is an enum list.

Aurelien

Hi @zacc_oraro

What @Steve was indicating, is about ticking the “label” option in your table.
This way, in enumList or anything that will refer to your table, the field ticked as “Label” will be shown instead of ref id.

zacc_oraro

Checked the box under “Label” but no luck yet. There might something Im not doing right?

This are the enum list on the other Table that is Ref to.

zacc_oraro

Sorry I Tried what you suggested, added new collumn in the sheet but still could not get it to work. Im sure there might be a app formula or something.

zacc_oraro

Im trying over and over again and its not even working. Anyone help please?

I want to see values in the data source (google sheet) not Reference IDs. The fields I want to see is are Reference Fields.

Steve

It’s clear you don’t understand references, so you should either spend some time learning how they work, or don’t use them.

What values do you want to see in your data source, if not reference IDs?