A problem with linking data between the program and the excel file

[arch_hazem]

I have a problem.. When I choose, for example, a project name from the App, it appears in the linked excel file, the project number, not the name..Is there a way to solve this problem

[Aurelien]

Hi @arch_hazem 

I'm afraid your question is unclear.

Would you attach some screenshots ?

[arch_hazem]

سؤ

[Aurelien]

Got it, thanks for the screenshot. I think you didn't get yet how referencing works 🙂

If you look to your Projects table, you'll notice the "350" you see will match with the Project you picked in the app.

This is because 350 is the ID of your project.

I suggest you read this:

https://help.appsheet.com/en/articles/895267-data-the-essentials

More specifically, please have a look to the section "Give Each Row a Unique Identity".

Moreover, I suggest you also have a look there:

https://help.appsheet.com/en/articles/961426-references-between-tables