I’m developing an app for electricity bill payments, and I’m facing an issue with retrieving data based on the logged-in email. Currently, I’m trying to fetch data from the column named “ค้างชำระ” after a user logs in. From the attached image, it appears that the data retrieval is not successful, and getting blank values. The expected outcome is for the app to retrieve data based on the ID used for logging in"Could you please help me solve this problem? Thank you in advance."
The code in this section attempts to compare the value entered as ‘userEmail’ with the values in the database under the column ‘colEmail.’ If it matches any row, it retrieves the value in the column named ‘ค้างชำระ’ of that row and stores it in the variable 'Value ค้างชำระ
We can’t help you without screenshots of your blocks or a link to your project. It’s like telling a doctor “I have a pain in my stomach” but then not letting the doctor examine you.
When using the Firebase Sign In blocks, you would typically not need the user’s email address. Everything in Firebase would be stored based on the user id. The only reason to store the email address is if you plan to send email messages to it.
And @Goldking is correct… you can’t compare values in a row id text field because that would only return “true” or “false” which are not row ids. You need to give it a row id value (a long string of numbers and characters) or an integer.
