Rule based on a Lookup additional field

[Gerard Graham]

Hi there

I have an activity log that a user selects a project from a lookup field. I’d like to have a rule determine what fields are visible/mandatory etc based on the value of an additional column associated to the lookup field. However, only the main lookup field appears in the list of fields. None of the additional fields are available.

Is there a way around this or is it possible to consider adding the additional fields as options?

Thanks

Gerry

[Alexander Bautz]

Hi,
These additional columns are only available in DispForm (like they are in normal SP forms). You can however use a “Custom JavaScript function” trigger to write your own logic based on a query to find the additional values for the lookup.

Let me know if you need help setting this up.

Alexander

[Charlie Bell]

Im looking to do just just this and could def use a little help mine is a little different so i will post a new thread..

[Author]

Posts