The following table outlines the types of fields that can be updated using the Field Update Keyword Action.
| FIELD TYPE | NOTES | EXAMPLE |
| Checkbox |
Only accepts the following values: 1 or Yes or TRUE (checked) / 0 or No or FALSE (unchecked) |
Prompt: Do you like using Mercury SMS? Reply #Mercury Yes or No Reply: #Mercury Yes |
| Currency | Only accepts a number value, with or without decimal places. Reply must not contain the currency symbol. If the field is set to no decimal places and the reply contains decimal places, the decimal value will be parsed to Salesforce.com and then rounded to the nearest whole value. |
Prompt: How much did you spend on your last holiday? Reply #Holiday [amount] Reply: #Holiday 5000.00 |
| Number | Only accepts a number value, with or without decimal places. If the field is set to no decimal places and the reply contains decimal places, the decimal value will be parsed to Salesforce.com and then rounded to the nearest whole value. |
Prompt: How old are you? Reply #Age [age] Reply: #Age 38 |
| Date | The date will be processed in the locale of the Mercury SMS Site Guest User. If the value does not match this format, it will not be updated. |
Prompt: What date would you like to have a demo of Mercury SMS? Reply #Demo [dd/mm/yyyy] Reply: #Demo 14/09/2016 |
| Text | Limited to the character limit on the field. If the response exceeds this length, it will be truncated (cut off at the end) to fit. |
Prompt: Let us know what you think of Mercury SMS. Start your reply with #Review Reply: #Review I think it’s awesome. Especially the Field Update Feature! |
| Text Area | Accepts line breaks. Limited to the character limit on the field. If the response exceeds this length, it will be truncated (cut off at the end) to fit. |
Prompt: Tell us 3 things you love about Mercury. Start your reply with #ILoveMercury Reply: #ILoveMercury SMS Feed Supports Salesforce1 Inbound Keyword Actions |
| Only accepts a single email address in an email format |
Prompt: Please confirm your email address. Reply #Email [address] Reply: #Email colin@email.com.au |
|
| Phone | Accepts alphanumeric values |
Prompt: Please confirm your phone number. Reply #MyPhoneIs [number] Reply: #MyPhoneIs +61 410 000 000 |
| Percent | Only accepts a number value, with our without decimal places. Reply must not contain the percentage symbol. The reply will be used as the final percentage value. If a reply is .50, it will update the field with 0.50% not 50% |
Prompt: What % of your communication is done via Mercury SMS? Reply #SMS [number] Reply: #SMS 80 |
| Lookup | Only accepts the ID of the record. |
Prompt: You have received a code via email. Please reply #SignMeUp [code] to complete your newsletter subscription. Reply: #SignMeUp 00Q90000011fJjl |
| Single Picklist | If your Picklist in Salesforce is set to "Strictly Enforce Picklist Values," then the reply will only update the field if it contains a matching value. If it’s not being enforced, the value will be added regardless of whether it matches an existing Picklist value. |
Prompt: What is your favorite app on the Extensions page? Start your reply with #App Reply: #App Mercury SMS |
| Multi Picklist |
Multi Picklist values should be separated with a semicolon (;). The reply will override any existing selected values in the field. If your Picklist in Salesforce is set to "Strictly Enforce Picklist Values," then the reply will only update the field if it contains a matching value. If it’s not being enforced, the value will be added regardless of whether it matches an existing Picklist value. |
Prompt: Which MessagMedia Apps do you use? Reply #MM [apps]. Put a ; between Apps Reply: #MM HubSpot; Mercury SMS; Shopify |