Page 1 of 2

Linking Pictures

Posted: Sat Jul 12, 2014 5:00 pm
by 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.


Linking Pictures

Posted: Sat Jul 12, 2014 7:23 pm
by 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.


Linking Pictures

Posted: Sat Jul 12, 2014 8:47 pm
by 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?


Linking Pictures

Posted: Sat Jul 12, 2014 8:53 pm
by 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.


Linking Pictures

Posted: Sun Jul 13, 2014 2:32 am
by Anthony Dre

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


Linking Pictures

Posted: Sun Jul 13, 2014 5:11 am
by Alena Prykhodko

Anthony,

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


Linking Pictures

Posted: Sun Jul 13, 2014 6:31 am
by 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


Linking Pictures

Posted: Sun Jul 13, 2014 6:36 am
by Alena Prykhodko

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


Linking Pictures

Posted: Sun Jul 13, 2014 7:24 am
by Anthony Dre

What would be the best way?

I have my Excel file like this
Image

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


Linking Pictures

Posted: Mon Jul 14, 2014 6:05 am
by Anthony Dre

??