FP <-> iTunes and GSX Integration

[Bryan VonDeylen]

I would like to create a database for our school district that would allow teachers to post the "Link" from the iTunes App Store database into a field in FP12, and then the FP12 database would access the other fields from iTunes (Name of App, cost of app, category, etc) into fields in FP12.

 

Then teachers would only need to open iTunes App Store, find their app, copy link and paste into a new record in FP12. Add their School, Grade (or Course) and Teacher Name to post all the apps required for students to download to their iPads.

 

Students would use FP GO, Enter their School / Gr (or Course) / Teacher and a list of Apps (with their links) would be presented for them to access. It would be nice if this list had the names of the Apps (pulled from iTunes DB). How do you connect a FP12 database to an iTunes DB though?

 

I would like to do the same for our FP12 Inventory database and connect it to the GSX database so when we look at our inventory, it would pull data from GSX (eg warranty information). How?