Personal Info
- Full Name
- Abdullah m Saleem Improve to make better
- [email protected]
- Phone
- 6126447993
- Phone 2
- 6126447993
- Order ID
- receeg6hue18wr1nd
- Customer #
- 612-605-1624
Property Address
- Street
- 61 Greystone Ave N
- City
- St Paul
- State
- MN
- Zip
- 55128
Billing Address
- Street
- To extract just the "HouseNumber StreetName" from the address in the format "HouseNumber StreetName, City, StateCode, Zipcode", use this formula in Airtable: LEFT({[email protected]}, FIND(",", {[email protected]}) - 1)
- City
- To extract the City from the address in the format "HouseNumber StreetName, City, StateCode, Zipcode", use the following formula in Airtable: `TRIM(MID({[email protected]}, FIND(",", {[email protected]}) + 1, FIND(",", {[email protected]}, FIND(",", {[email protected]}) + 1) - FIND(",", {[email protected]}) - 1))`
- State
- To extract the StateCode from the address in the field [email protected], use this formula in Airtable: ``` TRIM(MID( {[email protected]}, FIND(",", {[email protected]}, FIND(",", {[email protected]}) + 1) + 2, 2 )) ``` This will return the two-letter StateCode from the address.
- Zip
- To extract the Zipcode from the address in the field [email protected], use this formula in Airtable: RIGHT({[email protected]}, 5)
Office
- Office Address
- 50 S 6th St. Ste1390 Minneapolis, MN 55402
Service Details
- Lawn & Snow Customer
- No
- Auto Renewal Lawn
- —
- Auto Renewal Snow
- —
- Weed & Feed
- —
- Trigger Inch
- —
- Salt
- —
- Mowing Caution
- —
- Service Years
- 2025 Fall Cleanup
2026 Renewal Info
- Updated # of Mows
- —
- Mow Frequency
- —
- Lawn Only Renewal
- —
- Lawn + Snow Combined
- —
- Amount to be Charged
- —
Notes
- Office (Lawn)
- —
- Office (Snow)
- —
- Operator (Lawn)
- —
- Operator (Snow)
- —
- Cancellation
- —