Service Fee Quote

[GNS-Mississippi]

I love this idea - and I think I can take advantage of the query feature....maybe?
Your video here is the inspiration: https://www.youtube.com/watch?v=AvOWaoYZUMk

So - I am a home inspector. My fees are based on the sq ft size of a home. For example < 1200 sq ft = $360 - - - so, if I want to respond to a client looking for a quote, I want to send them an Email with a response based on my adding the footage size in the FastKey field and have the correct fee list in the email.

I can set up a spreadsheet, and if the query is larger than 1201 sq ft and smaller than 1500 sq ft, the price will be $400. The example would pull from a spreadsheet table and "lookup" the correct fee based on my query in FastKey?

Hi (Dave), The price for the (1260) sq ft home is ($400).

Visual Home Inspection Less than 1200 Sq Ft $360
Visual Home Inspection 1200 to 1500 Sq Ft $400
Visual Home Inspection 1500 to 1800 Sq Ft $445
Visual Home Inspection 1800 to 2200 Sq Ft $510
Visual Home Inspection 2200 to 2600 Sq Ft $570
Visual Home Inspection 2600 to 3200 Sq Ft $630
Visual Home Inspection 3200 to 3800 Sq Ft $690
Visual Home Inspection 3800 to 4500 Sq Ft $775

I understand how to set the file name. I'm going to assume this will work with Google Sheets. Can you guide me along with the correct function(s) to include?

[Tom]

FastKeys Table macros can lookup exact values. I suggest using the "Insert Command Code" macro where the possibilities are unlimited.

Hi %INPUT_Name%, The price for the %INPUT_Sq% sq ft home is %CODE_Price%.

Where the CODE_Price is

Code: Select all

if (INPUT_Sq > 3800)
	Send, $775
else if (INPUT_Sq > 3200)	
	Send, $690
else if (INPUT_Sq > 2600)	
	Send, $630
else if (INPUT_Sq > 2200)	
	Send, $570
else if (INPUT_Sq > 1800)	
	Send, $510
else if (INPUT_Sq > 1500)	
	Send, $445
else if (INPUT_Sq > 1200)	
	Send, $400
else 	
	Send, $360

[GNS-Mississippi]

Thank you! Perfect!