Linking Google Forms Entry to Current Data

I have a Google Form for Tenants to submit a maintenance request. I would like to be able to link that request to that tenant in my app. How would I go about automatically linking the two?

One way is to ask to fill the key value that belongs to that tenant into Google Form.

I thought about that, but I know people would lose those and then we would probably get less submissions. I want to make the process easy for them and easy for us.

Hey,

I’d say going by the tenants email addy is the safest thing.

1 Like

Oh duh, I didn’t even think about that. I will give that a try and see if it works.

1 Like

I assume tenants can send the submission freely, right? One way is to ask the email address, but then it’s possible that someone else send the submission if they know the email address. But you need to try to identify the user somehow, then it’s a question is it easy or hard to remember.

1 Like

That is kind of what I was thinking. We also get people who change their emails so that causes a problem. I would still appreciate any ideas that anyone might have.

To connect the maintenance request and tenant, you need to have a value in one column that matches. It can’t be an email, or date, etc. It needs to be unique which only the tenant knows.

If you would have a public app, the tenant could save the code to Usersettings and then they won’t forget it.

With the gForm you can also use prefilled values. One option could be to send an email to each tenant with the prefilled code and they would open the form from that email (link).

1 Like
  • i would make them sign in to submit the form
  • make a field in my tenants table a list of all that tenant emails
  • have each property in my property table linked to one tenant, either directly or through a “contract table”
  • make an onform submission script to take those requests and copy them to my app with their respective property

How does the tenant get access to the Google Form in the first place? Do they have to contact the office first?

1 Like