Linking Pictures

[Anthony Dre]

Im new to this and have a good exp with computers. Im making a search app that searches serials and pulls up (Serial, Item Name, And a Picture of that item). From a CSV Excel File that i upload.

My question is how to I make it that if you search up for say "G4738" It shows a Picture of that Item and if you search up "D4865" it shows that Picture of that item.

I have a file on my desktop with all my pictures and the pics are named with the serial numbers of the items.

Whats the best way to link them?

Gonna need a Step By Step aleast for 1 item so that i can learn.

[Alena Prykhodko]

Hello,

Please read more about queries here http://devcenter.appery.io/documentat...

You can create 2 columns in database: serial numbers of the item and link to file or file.

[Anthony Dre]

Database as in Appery or database as in Excel?

If i import the Excel file. does that mean i would need to add the link to file in excel or appery?

[Alena Prykhodko]

Appery.io provides a cloud database to store app data.
You can import a collection if you have a .json or .csv file.
Also you can add data manually.

[Anthony Dre]

So if i add the collection from a .csv file where do i do the Link to file

[Alena Prykhodko]

Anthony,

Sorry, not clear what file do you mean?
Source .csv file? Then you don't need to link it.

[Anthony Dre]

"You can create 2 columns in database: serial numbers of the item and link to file or file."
'
You said that i needed to add a column with link to file

[Alena Prykhodko]

I meant picture link or how do you want to store it in database.

[Anthony Dre]

What would be the best way?

I have my Excel file like this

So what would be the best way to get picture in app to show when looking up a certin serial

[Anthony Dre]

??