I have this error, and I don't know what's happening?
My app is like that:
when does the error happen?
after reading column Y or after reading a cell?
check your data in the spreadsheet... do you have for exampe an O'Brien?
Taifun
Also never store passwords in plain text in an online database...
your users want you to keep their data safe...
store password hashes instead of plain text
To store password hashes is very simple, the tools extension offers a method for that App Inventor Extensions: Tools | Pura Vida Apps
And later if you want to check, if the entered password is correct, compare the password hashes
Taifun
No, what's an O'Brien? I think that the error happen after reading column Y because the error is about Reading Column. Also, the passwords are for low safety, don't worry for being in an online database
A name which has a quote '
To find it out, just deactivate all blocks in the GotColumnData event and display the columnData in a label
I'm not worried, but as user I would be worried to use your app, which ignores basic security rules
Taifun
The error appears without anything on the GotColumnData block
The only thing we can do now is to check column Y... Do you like to provide your data here?
Taifun
well, are only names and some of them are like that
joseph.ha
rose
emma
dave.mo
Dear @ArniST,
sorry to bother you, but please take into great account the matter of security, as @Taifun has already highlighted. I've been for several years the responsible for cybersecurity and for privacy for a huge company, spread worldwide, and you never know what might happen if PII (Personally Identifiable Information) are stolen. If you don't grant "by default" and "by design" the security of Personal Data you might incur in legal infringments.The majority of Countries have adopted in the past years harmonized laws concerning Privacy (i.e. in Europe the GDPR), therefore if the passwords you store in your app, or used by your app, allow to get access to personal data of the users, you MUST (legally) protect them.
You say that the passwords used by your app are of low priority, but please be aware that the meaning of Personal Data is very wide: ranging from the e-mail address, to a photo, from the IP address to the name of kids....
As I said at the beginning, I don't want to bore nor to scare you, but just keep in mind what we (@Taifun and I) have said.
Best wishes for your app !
how many rows?
make a copy of the spreadsheet,
delete all rows except of the first 100, then try again
if it works, try 200 etc until you find the problematic row
Taifun
You could make one simple query to the spreadsheet:
query = SELECT Z WHERE Y = 'Textbox1.Text'
The spreadsheet component offers similar with the two filter methods
Well, I explain you, I solved a important thing, that was the shared by link google document. Now it has another error. To explain you, I wanted to do it in a second sheet with the name "CON" so the data of the user is on the column A and the password column B. So It doesn't work and show this error:
You are setting the range to CON!A:A
, this will not work.
Try
&gid=XXXXX
(where XXXX
is the gid for the sheet named CON
&range=A1:B1
(assuming your username is in A1 and your password is in B1)
Again this is more easily done using gviz
I tried this: https://docs.google.com/spreadsheets/d/DOCID/export?format=csv&gid=CON&range=A1:A22
There are only 22 rows. The problem is that I want a fast answer, so I want that the connection between the drive and the app is the fastest as possible. I don't understand really much this way that you showed me
Seems you did not properly read either of the guides I provided. Do that, and you should have your answers.
To help, the sheetName (CON) is not the gid number of the sheet, you will find the gid in the url address bar, when viewing the specific sheet (the first created sheet usually has gid = 0).
So what exactly prevents you from providing the complete column Y here?
Taifun
Probably it's the รง
?
make a copy of the spreadsheet,
delete all rows except of the first row, then try again
if it works, try 2 rows and finally 3 rows until you find the problematic row
Taifun