vlookup function
S
Scott Snyder
This could be a killer, missing feature in SmartSuite. Create a new function to be used in formulas that provides the ability to lookup and return data in a different application based on field data in the current record where the formula is being used.
Syntax example: LOOKUP([Current_App_Field],[Solution].[App].[Field],)
The formula instructs SmartSuite to look in the specified app for a matching value from the specified field in the current app, and then returns the value in the specified field in the app to which the function is told to lookup a value. This could emulate linking without having to manually link records or create an automation to do the linking. Would be very valuable.
Requirement is that lookups probably could only be performed against fields where unique values are required (as in primary keys) or you would have multiple record matches.
Brian Dollen
Merged in a post:
Add VLOOKUP form
S
Support/Integrations Team
Right now, the LOOKUP field is a little too limited and requires creating multiple fields in order to calculate a value based on fields in another table. A VLOOKUP would allow for more scalability within table creation.
S
Scott Snyder
I wholeheartedly agree. To me, there is no more important feature than this one. It takes SmartSuite into a whole new level of capability as a database. Techniques to fetch related data in other tables without the need to physically open each record to select a link are enormously powerful. Automations for this are cumbersome and needlessly complex. I am sincerely praying for this feature to gain the support internally that it deserves. I am thrilled with SmartSuite and want to see the company grow and adoption for their product explode and this capability is a huge differentiator. Keeping fingers crossed!
Others have recognized the utility of the feature as well: https://feedback.smartsuite.com/feature-requests/p/variables-in-formulas-or-script
Yocheved Zelishovsky
Scott Snyder I'm thinking that in the meantime this can be achieved via automation thought you would have to specify each individual app/table where the record may be