Sign up using google sheets via google form

Hi! I am trying to create a sign up screen for my app and I want to use Google Sheets as my Database, and got the link from the Google Form. I already changed the end of the URL to formResponse, but I can't seem to get the data. What did I do wrong?

thank you.

1 Like

Thank you so much.

Should I start studying this?

May I ask if you have a link, particularly talking Sign Up and Log In. I read some posts here about it, but I cannot find a similar problem with mine, other than they change the /prefill to /formResponse.

Thank you very much!

If you want to use the AI2 spreadsheet blocks, you need to go through the setup process for the Google Sheets API.

I like to stick to blocks only in my solutions, to avoid dependencies on extensions that eventually rot or don't run on iOS.

I prefer blocks to typing code.

If I could I prefer using blocks too. I already got the data without using the Google Sheets API but I used google forms instead. It is working now. Thank you.

Now I am working with the USER NAME and PASSWORD CONFIRMATION. Can I ask your suggestion about this one? I am currently working with the Google Sheets (SCRIPTS) do you think I should proceed here, or is there any blocks for confirming USER NAME AND PASSWORD?

Thank you! I am looking for some posts here in the community but I cannot find what I need. What is your advice on this one?

Every one in the world but me has a login scheme.

That's why I collected them in the Login FAQ a few posts back.

It's up to you to choose.

Did you publish your Google form, and give all respondents permission with Anyone with the link ?

yes. it is working now. thank you.

I am working with Username and password registration now. Which one is more understandable to use TinyDB or Apps Script of Google? Thank you.

Do you want to verify logins in the app or on the server?

I am making an app for Children so the simple one is okay with me, I don't know which one from the app or the server is the simplest one.

image

This is what I made for user name and password registration. the link that was attached is for Google App Script. What do you think is wrong here? Did I make the responseContent correct?

This is for registering the username and password.
image

How will I do it in TinyDB?

image
I made this one for TinyDB

You do not show your script...

Regardless, either approach should work, the choice is yours, you users should not notice the difference...

You say that you are using TinyDB but your block uses Tinywebdb.

And your block expects an immediate response from Tinywebdb.

That can't be right.

Read what you wright.

1 Like

Oh, that is why. I used. A wrong component, thank you so much!


This is what I have tried.
I am planning to use App script so there will be no limits. I read that if I use TinyDB there will be a limit,

What limit is that ?