Is it possible to access AI2 data from a website?

[He_Lene]

Hello,
my new question of the day is : is it possible to access/create/read AI2 data from a website ?

The (yet theoretical) situation is as follow : I create exercises for my users (patients), I can use several time the same exercice's structure only changing the words or pictures used. See it as the quiz structure.
I hate to type on the phone, and especially I hate to type on my patients phones. So I would like to type words or load pictures on my computer e.g. on a dedicated website, then update the patient's app to load the new words, so the patient can make the same exercise as last week but with different words/pictures.

I think I could use google spreadsheet to type the words but ... :

• it doesn't work for pictures (right ?)
• it is not very user friendly (e.g. if my colleagues start to use this same app with their patients)

Any idea for me ?
thank you

[TIMAI2]

Using google sheets (words) combined with google drive (images) is certainly one way you can do what you want.

See here for some ideas:

Is it possible to see images from the spreadsheet google?

I already got help from the forum and now I still need it! I wanted to use this spreadsheet project which works fine with text and numbers, but I don't know how to show the images of column "c" from the app when I press search Could I have suggestions? thanks [Bloc] images.aia (964.3 KB) link spreadsheet.txt (100 Bytes)

Use gviz to get and query google sheet data

[gvizscreen1] Guide on how to use the google visualization API to get and query "public" google sheet data Use gviz to get and query google sheet data Note: this approach has been knocking around for years, e.g. https://puravidaapps.com/spreadsheet.php, but I have never seen it "properly" explained like this...

Google Sheets - Simple Post and Get Data

Here, in my view, one of the simplest solutions to uploading and downloading data to a google sheet from AI2. Google Sheets - Simple POST and GET Data

[He_Lene]

Thanks,
Indeed I thought about Google drive, spreadsheet etc - as already said, it's not very userfriendly (if I'm not the user)
Is there a way to build a nice and userfriendly webinterface or webapp with AI2 for the computer ?

[Patryk_F]

@He_Lene

webinterface or webapp with AI2 for the computer

This part goes beyond AI2 and this forum.

But I think that on another forum you could find information on how to write a PC app that could put data in a google sheet, from which an android app would download data.

[He_Lene]

thanks for the idea, I even didn't think I could do that (looking on another forum)
now I know that AI2 won't do that for me (and I am not sure I will look further, it was just a theoretical question for the moment ... I have enough to learn with AI2 without searching outside of AI2)
Have a nice day everyone here

[Patryk_F]

In ai2 you could create an app just for putting data into a sheet, but it's still typing on the phone and not on the pc.
There are also google forms that can be used to insert data into a spreadsheet.