.png){kind=logo}
Resolving Table Selection Issues with GUUID in Database Queries
Hey Guys, how do I resolve this?? I have a selection in one table but other table sees this as a GUUID rather than actual selection:
Hey Guys, how do I resolve this?? I have a selection in one table but other table sees this as a GUUID rather than actual selection:
The “select” column type is visible as a random number, not the actual value
When transferring data between tables, if you see a GUUID instead of the actual selection, the value likely isn't formatted as a list. Add the list through the "Other data from this table" section when using write to table. If you're referencing newly created columns from one table in another table's formula, you need to re-run the company row in the people table and force run through the whole column to see the new values. For proper data transfer between tables, use the Lookup Rows feature to search and retrieve data from other tables, or use the Send table data action to transfer specific columns while keeping data aligned.
When transferring select column data between tables, the GUUID appears because the value isn't formatted as a list. To fix this, add the list through the "Other data from this table" section when using write to table. The select column data type accepts predefined tags for categorizing contacts and companies, but when transferred improperly, it shows the internal identifier instead of the display value. Use the Send table data feature to properly transfer specific columns while keeping data aligned between tables.
I’m not using write to table. I’m using lookup single row
The select column data type accepts predefined tags for categorizing contacts and companies. When using lookup single row between tables, the GUUID appears because select columns store internal identifiers rather than display values. To resolve this, ensure the source table's select column has the proper predefined tags configured. The lookup single row feature retrieves data from other tables but may show the internal identifier instead of the readable value for select columns. Consider using a text column instead of select if you need the actual display values to transfer properly between tables via lookup.
Select columns store predefined tags for categorizing contacts and companies, but when using lookup single row between tables, they display internal identifiers (GUUIDs) rather than the readable display values. To get the actual display value instead of the GUUID, consider switching the source column from "Select" data type to "Text" data type. This will ensure the readable values transfer properly between tables via lookup operations. What specific values are you trying to display in your select column - are they status labels, categories, or another type of classification?