Computed Attribute fields on documents automatically populate based on contents of other attribute fields. A SQL Case Command entered at the Application level drives this automatic process.
1. Add the attribute to Identifi, if it's not already there.
2. Add the attribute to document types.
3. At the Applications that this attribute is now part of (based on the doc types it's been added to), locate the attribute in the list and open its details.
It is here that the 'Case' command is entered in the Compute Formula field.
(case when_FIRSTATTRIBUTE is NULL then 'SOMETHING' when _SECONDATTRIBUTE = 'SOMETHINGELSE' then 'SOMETHINGELSE' else 'ANOTHERTHING' end) |
Note: The attributes must be entered exactly as they are named in the database. To double-check your titling, look at its column name in the main attribute list.
Best Practice: To avoid syntax errors, copy and paste the formula from another attribute and edit it for the specifics of the attributes involved.
Remember, this formula must be entered for the attribute at every Application it is associated with.
Comments
0 comments
Please sign in to leave a comment.