Expanding Possibilities with Formulas

Expanding Possibilities with Formulas

Hi,

I know this will probably either be ignored or responded with; "We will evaluate the request for the possibility of including this feature in a future update", but I thought I would post this anyway.

Rather than simply returning 'True' or 'False' for many functions we should be able to set what the response will be.


Something along the lines of...

If(${Invoices.Grand Total}>500, Big Deal, Regular Deal)

To return Big Deal if the price is over $500, and return Regular Deal for less than $500


Similarly could we use the If function for more than just Boolean, as this would be very helpful to intertwine and automate many processes.

For Example...



If(${Invoices.Subject} contains Car, Vehicle, Product)

To return Vehicle if the word car is in the subject field, and return Product if car was not present.

These are very simple examples of extending the use of the If function. We are a newspaper and could greatly benefit from having a field that recognizes a publication selected and automatically returns the dates the advertisement would run.

The formula field needs to have more possibilities to make this CRM easier and quicker to enter data, and as a result streamline the whole process.

If anything can be improved to the formula field, it is a step in the right direction.

Thanks,

Adam