Google Automated Form Ex
Click here for Top Ten Discussions. CLICK HERE for Q & A Homepage
Receive Free Rental Owner Updates Email:  
MrLandlord Q & A
     
     
Google Automated Form Ex (by Jason [VA]) Mar 19, 2023 7:40 PM
       Google Automated Form Ex (by BRAD 20,000 [IN]) Mar 19, 2023 8:28 PM
       Google Automated Form Ex (by ned [AL]) Mar 19, 2023 9:44 PM
       Google Automated Form Ex (by Jason [VA]) Mar 19, 2023 10:03 PM
       Google Automated Form Ex (by GLR [MA]) Mar 21, 2023 3:30 PM
       Google Automated Form Ex (by 6x6 [TN]) Mar 21, 2023 8:31 PM
       Google Automated Form Ex (by 6x6 [TN]) Mar 21, 2023 8:34 PM
       Google Automated Form Ex (by Jason [VA]) Mar 21, 2023 8:41 PM
       Google Automated Form Ex (by John... [MI]) Mar 21, 2023 11:22 PM
       Google Automated Form Ex (by Jason [VA]) Mar 21, 2023 11:56 PM
       Google Automated Form Ex (by 6x6 [TN]) Mar 22, 2023 6:46 PM
       Google Automated Form Ex (by Jeffrey [VA]) Mar 22, 2023 9:50 PM
       Google Automated Form Ex (by John... [MI]) Mar 23, 2023 7:58 PM
       Google Automated Form Ex (by Kevin [FL]) Mar 24, 2023 3:45 PM
       Google Automated Form Ex (by Jason [VA]) Mar 24, 2023 8:05 PM
       Google Automated Form Ex (by Jason [VA]) Mar 25, 2023 11:57 PM


Google Automated Form Ex (by Jason [VA]) Posted on: Mar 19, 2023 7:40 PM
Message:

Here is the google auto screener form that I use:

forms.gle/ke1xeidKUWbxuuf59

In order to see it in action, just provide a valid email address when you fill it out.

I'm an Automation Engineer, so I enjoy making projects like this in my free time. Behind the scenes is 2,000+ lines of code that screen against whatever criteria I turn on or off.

I can specify different criteria for different properties, all using the same form. Here's everything that it will screen against (all can be enabled/disabled in a simple spreadsheet). I have exceptions configured as well so that if an applicant has good credit, it won't automatically reject them, but prompt me for a manual review (If I enable that feature):

ENABLE AUTOMATION REJECTION EMAIL SCRIPT?

EMAIL YOU WHEN SOMEBODY FAILS PRE-SCREENING?

EMAIL YOU WHEN SOMEBODY PASSES PRE-SCREENING?

SEND CONFIRMATION EMAIL TO APPLICANTS THAT HAVE PASSED PRE-SCREENING?

EMAIL ADDRESS TO NOTIFY ME AT:

SCREENING CRITERIA:

RENT MULTIPLIER:

ALLOW SMOKERS?

ALLOW BANKRUPTCY?

ALLOW PREVIOUS EVICTION?

ALLOW PREVIOUS CIVIL JUDGEMENTS?

ALLOW FIRST TIME RENTERS OR THOSE STAYING WITH FAMILY?

ALLOW HOTEL/MOTEL DWELLERS?

MINIMUM CREDIT SCORE :

REQUIRE ALL ADULTS TO MEET MINIMUM CREDIT?

MAXIMUM ALLOWABLE LATE RENT PAYMENTS (PREVIOUS 2 YEARS):

MAXIMUM NUMBER OF ANIMALS ALLOWED:

ALLOW CATS?

ALLOW KITTENS?

IF CATS ALLOWED, ALLOW UNFIXED?

ALLOW DOGS?

ALLOW PUPPIES?

IF DOGS ALLOWED, ALLOW UNFIXED?

ALLOW AGGRESSIVE BREEDS?

EXCEPTIONS:

CREDIT EXCEPTION LEVEL

REQUIRE ALL ADULTS TO MEET EXCEPTION CREDIT?

EXCEPTIONS FOR MILITARY PERSONNEL?

The program will not reject for any animal claimed as a service/support animal and I also have an "aggressive breed" list that it will screen against.

I have a Property database where I can select different screening criteria for each. For example, for properties with carpeting (very few left), I can turn off the "allow pets" feature. For smaller properties I can turn on the "allow first time renters" feature. If I ran a rooming house, I would turn on the "allow motel/hotel dwellers".

The entire system is 100% automated with no user intervention required after it's all set up. I've done projects for several other landlords in my area and after using my system, they'll never go back to the old way of screening. If you'd like me to help you getting this set up for you, leave me a note in the "WOULD YOU LIKE TO PROVIDE ANY ADDITIONAL INFORMATION OR COMMENTS?" section.

--71.63.xx.xx




Google Automated Form Ex (by BRAD 20,000 [IN]) Posted on: Mar 19, 2023 8:28 PM
Message:

Jason,

Impressive!

BRAD --73.103.xxx.xxx




Google Automated Form Ex (by ned [AL]) Posted on: Mar 19, 2023 9:44 PM
Message:

Jason-

Huge obvious advantages to automating the pre-qualification process.

What, if any, disadvantages would you say there are related to your system? --70.92.xx.xx




Google Automated Form Ex (by Jason [VA]) Posted on: Mar 19, 2023 10:03 PM
Message:

Ned, the one major disadvantage is that I don’t get to spend hours of my life listening to every deadbeat’s sob story.

My last vacancy, I did the math. If I would have spent just THREE minutes communicating with the people that didn’t qualify, I would have wasted ELEVEN HOURS of my life. Just a simple copy/paste text conversation eats up more time than that though.

There are no disadvantages. If they fill it out, that’s “cooperation”, which is the first thing I screen for. If they don’t fill it out, they probably can’t be bothered to do other things like taking care of a yard.

I screen for black and white. If the prospect doesn’t pass but they can “explain”, I don’t care. I wont “work with them” now or ever. So it COULD be a disadvantage for landlords that do “work with” people.

--71.63.xx.xx




Google Automated Form Ex (by GLR [MA]) Posted on: Mar 21, 2023 3:30 PM
Message:

Jason -

Thanks for the tidbit. I changed mine from questionnaire to "show request form", just like you did. So many people balk at filling it out in the past. Lets see how it goes. --73.17.xxx.xx




Google Automated Form Ex (by 6x6 [TN]) Posted on: Mar 21, 2023 8:31 PM
Message:

Thank you Jason.

You are very talented with the computer. --98.40.x.xxx




Google Automated Form Ex (by 6x6 [TN]) Posted on: Mar 21, 2023 8:34 PM
Message:

Did you create these codes yourself, or is this already a part of the Google forms? --98.40.x.xxx




Google Automated Form Ex (by Jason [VA]) Posted on: Mar 21, 2023 8:41 PM
Message:

It was all custom work to screen exactly how I’ve told it to. My code has been pulling double time these past few weeks dq’ing every deadbeat in town. --50.219.xxx.xxx




Google Automated Form Ex (by John... [MI]) Posted on: Mar 21, 2023 11:22 PM
Message:

I'd be interested in taking a look and modifying it for myself. Is this something you mean to be giving away for those of us who would like it? Or are you looking to sell your time to implement it? I wasn't sure from your post. Thanks!

--75.129.xx.xx




Google Automated Form Ex (by Jason [VA]) Posted on: Mar 21, 2023 11:56 PM
Message:

John, the form is less than one percent of the work I’ve put into my system. Anybody on this forum can copy my form questions and style. That will get them one percent of what it’s designed to do.

I’ve invested quite a bit of time with the data validation regex behind the scenes of the form so that the prospects fill out exactly what I want and how I want it. That’s the other 1% of the work. The remaining 98% of the work are the 2000+ lines of JavaScript code running it in the background that does all of my screening/rejecting/emailing/highlighting for me.

I’d be happy to help anybody in this forum get theirs set up (I can do custom work as well), but with as much time as I’ve invested, it’s not something that I can give away. --50.219.xxx.xxx




Google Automated Form Ex (by 6x6 [TN]) Posted on: Mar 22, 2023 6:46 PM
Message:

Thank you Jason. It would take me years to figure out all you have done. I am not very computer savvy. I do good to be on this forum. I would say your program is worth it's weight. --98.40.x.xxx




Google Automated Form Ex (by Jeffrey [VA]) Posted on: Mar 22, 2023 9:50 PM
Message:

Jason, I'd encourage you to consider being a sponsor to this forum or at our upcoming Convention.

In that way, we could help you promote your outstanding program (and offer to help others set it up or custom work) to all those who visit this website and/or who attend our Convention.

I bet there are many landlords who would be interested and willing to pay a reasonable price to use your time saving screening tool and benefit from all the time you have invested. --172.56.x.xx




Google Automated Form Ex (by John... [MI]) Posted on: Mar 23, 2023 7:58 PM
Message:

Jason: To be clear, I'm well aware that most of the work is behind the form, of course. I was a software developer for over 20 years. I understand that most of the work is behind the scenes. :)

I was just asking your intentions here. Some people give away things and some people don't. I just wasn't sure what you were offering and wanted clarification. Thanks.

--75.129.xx.xx




Google Automated Form Ex (by Kevin [FL]) Posted on: Mar 24, 2023 3:45 PM
Message:

Jason, sent you a request. --47.202.xxx.xx




Google Automated Form Ex (by Jason [VA]) Posted on: Mar 24, 2023 8:05 PM
Message:

Thank you for the invite Jeffrey, I'll give it some consideration. --71.63.xx.xx




Google Automated Form Ex (by Jason [VA]) Posted on: Mar 25, 2023 11:57 PM
Message:

I just tweaked the code a bit (since this is just an example). Now when this form is submitted, it will send two emails: One that the prospect would normally receive and one that the landlord would normally receive. If screening is passed, it will send the landlord a summary of the prospect's information. If they fail, it'll send a "swing and a miss" email with the reason attached.

forms.gle/CJG1aaiP37UpBdA87

--71.63.xx.xx





Reply:
Subject: RE: Google Automated Form Ex
Your Name:
Your State:

Message:
Google Automated Form Ex
Would you like to be notified via email when somebody replies to this thread?
If so, you must include your valid email address here. Do not add your address more than once per thread/subject. By entering your email address here, you agree to receive notification from Mrlandlord.com every time anyone replies to "this" thread. You will receive response notifications for up to one week following the original post. Your email address will not be visible to readers.
Email Address: