main table and referenced table id have different id in appsheet database

[Julienec]

Hi Everyone,

I created an application with two tables: ‘Sales Monitoring’ as the main table and ‘Request List’ as the referenced table. Whenever I input data, the application shows that the Project ID value matches a Request ID. However, upon checking the AppSheet database, the Project ID and Request ID do not match. My question now is how do I populate or display the actual database Request ID in the application? Thank you

[jaichith]

did you use UNIQUE() function ?

How did you get such a long ID ?

[Julienec]

Yes, @jaichith , I used the UNIQUE() function. I’m not sure why such a long ID is being generated in the AppSheet database. That’s actually my question as well.

[Steve]

I recommend not using AppSheet Database. I prefer Google Sheets.