A question from someone who has no general coding or development background but who has had fun so far (and learnt a lot) getting my prototype app working.
My app has a timer (i.e. stop watch…) on certain pages and I have various components that display metrics depending on the timer value which generally starts running when a page is opened…and the value for these metrics sit in a table which I reference with functions. It is a simple table – ~300 records, 6 columns.
I have imported the table as a Data Variable a few different ways (Airtable, Firestore, etc - see the detail below under ‘What I have done’) but thought it worth asking if I am going about this the right way?
Is there a better way to do get the data into the app? Perhaps have it in there ‘permanently’ rather than importing it each time a page is opened?
When I originally tested my approach and functions, I used various Page Variables…but it looked to me as if that functionality is not appropriate for holding a table with 300 rows…and only one column of my table was possible per variable…but it was all learning.
With an API and pulling the table and storing it as a ‘Data Variable’, how does that work in basic terms? I assume the data variable is populated each time the page is opened because I don’t have any user actions that prompts it? And I assume the Data Variable is cleared when the page is closed, as my usage on Firestore UI indicates I am calling it each time the page is opened? Is there a way to import the table once as a ‘Data Variable’ and have it saved in the app?
I have seen mentioned on the forum that Appgyver is developing its own database functionality…I think that would simplify my world, but not sure when that will be released. And I sort of have this, perhaps petty, desire of using Backendless rather Google Firestore but I actually have had success with Firestore with the table…
What I have done;
- tried to figure out how to store the table on appgyver but eventually came to the conclusion the data functionality is more geared towards the app user creating records, rather than storing static data that underpins the app
- used Page Variables with Variable Value Type = List to test functions but these cannot store a table…
- used Airtable – easy to go from Excel to Airtable with the data and got everything working with an API but ran into the pagination issue
- used Airtable but this time with http request…almost got it working (lots of help from the forum) but gave up for a few reasons
- used Firestore as it is easy to get around the pagination issue…but getting the data into the database took some time…but it works 100%. But I am now paying for usage which may become an issue if the app is popular
- now trying Backendless for authentification and a few other things, so looking at their database and have run into the pagination issue again…I liked the idea of using Backendless for everything but not sure I want to go down the pagination rabbit-hole again.