String too long for list? - TinyDB issue

MIT App Inventor Help
#1

Hello friends!

One of my apps is designed for professional drivers and offers the possibility to store comments for certain addresses. Comments are stored together with the address in a list and in TinyDB.
When restarting the app, an error message appears, which seems to occur only when a comment has been too long. Because I suspect the problem is really due to length, I would like to know what the maximum length of a list entry is. Could it also be due to something else, I would be very grateful for any hints.

Many greetings

photo_2023-03-10_21.28.21
photo_2023-03-10_21.28.211080Ă—640 73.4 KB

Screenshot_2023-03-10_21.29.11

#2

Could you capture that TinyDB value into a global variable, and apply some diagnostic blocks to it?:

  • is a list?
  • Do It (Companion Blocks Editor comment bubble)
  • length of list

Also, which type of ListView (MainText / MainText and DetailText, etc..) is ListView_Notizen?

Also, why do you store all your addresses and comments under one tag?
Would one address per tag be simpler?

P.S. TinyDB is stored only on the current device.
Would your proffesional driver want to share comments on an address with other drivers, like in a shared Google Sheet?

1 Like
#3

Thank you very much for your reply.

I will try to use diagnostic blocks.
Unfortunately I am still a beginner in app development with MIT App Inventor. Therefore, there is a lot I may not know or understand yet.
Because the particular comment always refers to only one particular address, these two pieces of information should be displayed at the same time.
ListView is currently set to "MainText". I had tried to use ListView with the layout "MainText,DetailText(Vertical)", but this did not work at all, because the information was displayed separately.
Drivers don't need to share the comments with others, just save them for themselves. Therefore a Google Sheet will not be necessary.

Screenshot_2023-03-11_05.06.52
Screenshot_2023-03-11_05.06.52580Ă—587 127 KB

#4

TinyDB2.GetValue is not a list (after Button_Notiz_speichern has been clicked):

grafik
grafik904Ă—457 94.7 KB

What is the goal of the app? Why should it be displayed in a ListView?

#5
#6

This type of app is so simple, it's easier to just post a sample.

This is a note taking app for addresses in Washington, D.C., with a couple of sample addresses and notes...
blocks

Capture
Capture329Ă—650 49.1 KB

Capture2
Capture3
Designer
Designer695Ă—354 44.4 KB

TinyDB_Address_Notes.aia (2.3 KB)
when btnSave .Click do
when btnSave .Click do950Ă—414 50.6 KB

when lpkAddresses .AfterPicking do
when lpkAddresses .AfterPicking do1368Ă—284 43 KB

when lpkAddresses .BeforePicking do
when lpkAddresses .BeforePicking do1034Ă—130 20.4 KB

1 Like
#7

Well, it seems that all TinyDB tags previously saved with other apps are also listed here - at least while testing with Companion.

#8

Thanks to all your helpful comments, I managed to solve the problem.
I got rid of the list because it was indeed redundant.
TinyDB together with an additional label did the trick.
You're awesome.

1 Like
#9

Fine, then post your blocks so that others can also learn from it.

#10

I would have suggested something like this:
TinyDB_Address_Notes2.aia (3.5 KB)

grafik
grafik1704Ă—762 102 KB

#11

A TinyDB Namespace of 'addressNotes' would have avoided that, had I given a hoot.
TinyDB_Address_Notes.aia (2.4 KB)

when Screen1 .Initialize do
when Screen1 .Initialize do900Ă—130 16.8 KB

1 Like
#12

Here are the new blocks:
Screenshot_2023-03-12_18.38.23
Screenshot_2023-03-12_18.39.33

1 Like
#13

Thanks for sharing Heidar, much appreciated.

1 Like