Good day everybody. I have just started learning AI2 and am still quite lost. My data is in a Google Sheet and I have successfully connected to it. Now I am trying out designing an app for my charter transport business.
I want to read a range from my sheet and display it in the current screen. I am using a list component. To read data from the sheet I use Metricrat's GS Connected but how do I display the result of the Call function in the list?
Many thanks
Herman
Hi Herman,
What does your range look like? Single column or multiple columns?
Do you want to display your data in a table (like on the spreadsheet) or in a record format (YAML)?
Which "list" component are you hoping to use, listpicker or listview, or something else ?
1 Like
Hi @TIMAI2 , thanks for the quick response.
I am currently just checking out "procedures" I would use in my app. The range I used was 5 rows x 2 columns but in my app it would probably be a single column.
As far as display goes, probably in a table but only because I'm not sure what a YAML looks like...
Same for list component - I used listview because it sounded correct. But for displaying a list where the user has to select one - like names or dates - probably listpicker? I really do not know yet, this is my first venture into AI/Kodular.
For background and to help you understand the context of future questions, this is what I need to do:
I have a small company that transports kids between boarding schools in 2 neighboring towns and their home towns on weekends, during school terms only (duh!). Parents "register" to make use of the service and mostly pay a fixed monthly fee (with some exceptions that pay per trip.)
I am currently using another cloud-based app but it is much more expensive and limited.
So I need to:
-
Have an onboarding system to register new clients, that will add the kids needing transport to the app also.
-
Once registered, parents and children should automatically login after one-time authentication.
-
Parents will book their kid(s) for the upcoming weekend - both days in one booking by selecting the direction of travel (one or both). Parents can only book their own kids and those with more that 1 must select them one by one. The Trips table will distinguish who is on the bus by the direction of travel choice.
-
2 reports are generated from the bookings for each date/direction for pickup and drop-off, with info such as the place, kids' names, times etc. for the kids (pickup times), parents (dropoff ETA) and drivers (all info). Basically the same info for parents and kids, with some additional info and functionality for drivers - such as a button to write actual p/u and d/o times to the table.
These are my core requirements. Everything else is just icing on the cake.
So I need to know e.g. how to get the data for the "reports" - actually a screen accessible to all - and display it on the screen so that everyone can see the pickup and dropoff schedules.
Attached are screens from my current app.
In a listview, something like this:
-------------
name: Tom
age: 24
city: Hamburg
-------------
name: Herman
age: 37
city: Berlin
-------------
and so on...
Pick your builder and stick with it, don't try to mix the two, it will not work.
Ah, we have moved on quite a bit from displaying a range in a list !!
Hi... you got me confused now by saying I must pick a builder and stick with it. I thought Kodular is the successor to AppInventor, or is the same as AI2.
I'm working in Kodular Creator. I checked AppInventor now and it looks like an older version of Kodular. So no problem, I've never used it. Didn't know it still exists.
Thanks for the feedback. Yes, I have a long way to go to replicate my old app in Kodular!
You should then be asking questions on the Kodular community.
AppInventor is the original distribution. Kodular is a fork of the sources, not a successor.
Ok thanks! Much appreciated.