Tracking old applicants (by WMH [NC]) Apr 20, 2021 12:19 PM
(by Laura [MD]) Apr 20, 2021 12:28 PM
(by Robert J [CA]) Apr 20, 2021 12:29 PM
(by 6x6 [TN]) Apr 20, 2021 12:40 PM
(by JB [OR]) Apr 20, 2021 12:46 PM
(by Jason [VA]) Apr 20, 2021 1:07 PM
(by WMH [NC]) Apr 20, 2021 3:56 PM
(by WMH [NC]) Apr 20, 2021 3:57 PM
(by DJ [VA]) Apr 20, 2021 4:37 PM
(by Jason [VA]) Apr 20, 2021 5:02 PM
(by WMH [NC]) Apr 21, 2021 7:58 AM
Click here to reply to this discussion.
Click Here to send this discussion to a friend
Tracking old applicants (by WMH [NC]) Apr 20, 2021 12:19 PM Message:
Tracking old applicants pays off. I can barely remember what day it is, let alone people who have inquired about our places, especially if no application, just inquiry. But I remembered this guy, he's listed in red.
So thanks to our prescreening questions feeding to a back-end Google Sheet, I was able to turn down a real trouble-maker from a few months ago. I mentioned him here: he called me multiple times in a row, texted me, swore at me, threatened to keep calling until I reminded him I had his name and number and that it was now harassment. Also because I had already rented a place he wanted to see.
Today his GF inquires...mentions him as the second occupant...obviously doesn't know about our previous encounter.
Anyway, shot out my "attitude" email (one of several pre-set emails I have) and let it be. --50.82.xxx.xxx |
Tracking old applicants (by Laura [MD]) Apr 20, 2021 12:28 PM Message:
Yea, another victory for a well run business!
--108.56.xxx.xx |
Tracking old applicants (by Robert J [CA]) Apr 20, 2021 12:29 PM Message:
You are so good to track applicants going back so far! --47.155.xx.xxx |
Tracking old applicants (by 6x6 [TN]) Apr 20, 2021 12:40 PM Message:
So, when they filled out your prescreen form then the name brought up the old prescreen? --73.120.xx.xxx |
Tracking old applicants (by JB [OR]) Apr 20, 2021 12:46 PM Message:
I remember you mentioning this guy and talking about how you dodged a bullet with him many months ago. I don't think I'd forget him no matter how bad my memory was getting. --73.25.xx.xxx |
Tracking old applicants (by Jason [VA]) Apr 20, 2021 1:07 PM Message:
I have the conditional formatting on my spreadsheet set up to highlight duplicate entries for telephone numbers, names, and email addresses in bright yellow. If anyone fills out the form more than once, it'll grab my attention.
I make additional notes on the weirdos too, but highlighting helps me to me keep track of how often people are hopping around house to house. --73.177.xxx.xx |
Tracking old applicants (by WMH [NC]) Apr 20, 2021 3:56 PM Message:
Jason, how do I use that? Although I get multiple inquiries from the same people during the same day, because I deal with a lot of idiots... --50.82.xxx.xxx |
Tracking old applicants (by WMH [NC]) Apr 20, 2021 3:57 PM Message:
For instance, just had a guy tell me they had just acquired seasonal jobs here and were sub-letting their place up north. My auto-email says we don't do seasonal, only long term. He writes back "Okay we'll sign a year's lease."
Ummm. No thanks. --50.82.xxx.xxx |
Tracking old applicants (by DJ [VA]) Apr 20, 2021 4:37 PM Message:
Wanna bet they do not have permission to sublet their place up north, either? --68.229.xxx.xxx |
Tracking old applicants (by Jason [VA]) Apr 20, 2021 5:02 PM Message:
WMH, on the spreadsheet select the column that contains the data you'd like highlighted. Right click and then select "conditional formatting". Click on "add rule", then
under "format cells if" select "custom formula is".
The custom formula is =countif(B:B,B1)>1 and then under "formatting style" select the color you'd like it to highlight. Just change the "B" in the above example to whatever column you're working with.
Then if any data in that column is duplicated, it will highlight the cell. The only drawback is with telephone numbers. It won't recognize (123) 456-7890 and (123)456-7890 as a duplicate. This is why I configure my form to only allow numbers. No spaces or symbols: 1234567890. It makes it easier for the sheet to track duplicates that way. --172.56.x.xxx |
Tracking old applicants (by WMH [NC]) Apr 21, 2021 7:58 AM Message:
Thank you! --50.82.xxx.xxx |
Click Here to send this discussion to a friend Report discussion to Webmaster
Reply:
|
|