Get Reference ID in custom widget instead of "Show Column" value

Sao · December 2, 2022, 2:00pm

Hello,
I wanted to get the reference id of a field but instead I had the “SHOW COLUMN” value (string)
so I changed it to be able to use the id : this.data[0].catalog.rowId
Is it the right way ?
Is it possible to get always the ID ref in an object like if I choose “Row ID” even if there is a string in “SHOW COLUMN”

natalie-grist · December 2, 2022, 2:20pm

Hi there,

You could use that reference column in a formula to pull the ID, using dot notation, the format would be $REF_COL_NAME.id where REF_COL_NAME is the name of the reference column. For example, I have a table with a reference column labeled Title. So my formula is $Title.id

When I change ‘Show Column’ to Row ID, you’ll see the IDs match between the Title and ID column.

Thanks,
Natalie