I really appreciate your help here and here , what I like to do is to create an action while clicking the “Stock Pick” card layout which should take me to different screen and should able to show me data from different Google sheet… I created 2 collections here one is Menu and second is stock pick which is separate sheet.
One more question, since I am using sheet DB where I can only create 2 Collections and I am just wondering if I can use Google Sheet API(developer.google.com) within Adalo as I used Sheet DB.
So different item different collections? Why is that? You can use a one collection for all the items right?
With a external collection we can’t get the data that Google returns due to a limitation as far as I’m aware and Adalo is working on that. Creating, Updating, Deleting is possible with a custom action.
It’s good that this already in pipeline as this will surely cut down cost for people like me who are trying to build App using Google sheet. I can use Adalo’s local database and reason of using google sheet is to get updated ticks of stocks and if this can be achieved using Adalo then I can live without sheet.
Sorry for delayed response as I am working professional.
“Get updated ticks for stores” means that the stores need to update with some external info? You could use something like Integromat, Zapier?
And yeah if Adalo adds the ability to connect Google sheets, Airtable, Xano and some other databases directly by just selecting the sheet, table and without connecting them with external collections that would be great! This would be super duper cool!