More formula options for SFM

More formula options for SFM

Currently the SFM formula for transactions are very limited, it should support to go a level deeper to check/fetch certain values of records in lookup fields.

What is the underlying problem do you intend to solve with this idea?
Get the record id from a filled in lookup field
How is the problem being addressed today, if at all?
Create a separate lookup field with process builder to populate another field with the value.
Product Area?
Communities Installed Base Management Warranties & Contracts Work Order Management
What version of ServiceMax are you on?
Summer 16
6 Comments
Pastry Chef acooper
Pastry Chef

Agreed, just like Salesforce formulas work where you can traverse the relationships. E.g. you can pull data from the component, case or account related to the Work Order, all from a formula on the Work Order.

Roast Chef nick_sauer
Roast Chef

ISNULL and ISNOTNULL would be helpful. 

I have a scenario where Roll-up functions hit a snag if list of <tab name> have a null value, and seemingly no variation of attempting null checks work here. 

Roast Chef mark_taylor
Roast Chef

ISNEW would be helpful too. Assuming its inverse would be available too - NOT(ISNEW)

Product Team
Product Team
Status changed to: Not Planned
 
Staff Chef richard_lewis
Staff Chef

Hi @shivaranjini_g , please share details of why this is not planned for implementation.

Regards, Richard

Product Team
Product Team

@richard_lewis  New functions support for formulas is not immediately on roadmap. We will be revisiting this idea along with any other improvements, once we have new designer released which is due for 19.3