Data lookup definitions and dot walking

[robbika]

We have set up data lookup rules for filling in the assignment group on an Incident form.

The matching fields include thing like Category, CI, and location.

Now location is a very fine grained field. It maps to an actual location after all.

What we would like to do is to match on the country of the location; i.e. the assignment group depends on the country that the selection location is in.

We haven't found any good way to do this. It seems that for data lookup definitions it will only allow to use fields on the form that are writeable, and not something related to that field, like the country of the location.

I've thought about having an extra field on the form for country which is set when the form location is set, but that should either be read-only or invisible both of which I think don't work.

Anyone with any ideas on this?

[robbika]

Already data lookup rules are being used and it works fine. The user is finished when they hit Save or Update.

All I want to add is country. We already have Location, Category, CI, and it works, but it means that we have tens of thousands or rules for one customer that has tens of thousands of locations when really we could have hundreds based on country.

75,000 down to 500 is much more manageable and also means that it is likely that few extra entries would need to be made which massively cuts down on maintenance and mistakes.

What I did try was a calcuated field on the task record that automatically gets assigned the country from the location, but that didn't work. I might try out a plain string field plus a client script that sets it each time the location field is changed.

I don't see why it shouldn't in theory be possible to add dotwalking to this feature, although I'm not sure. As long as the base field is on the form, in theory it should be possible to dotwalk it. I'm likely not clever enough to extend the actually feature in that direction myself though.

[marcguy]

noticed actually that we added u_country to our incident form on a hidden tab

populated via a BR: Set Info from Location:

when: before

Insert-true

update-true

condition: current.location.changes()

(function(){

    current.u_city = current.location.city.sys_id;

    current.u_country = current.location.country.sys_id;

    current.u_region = current.location.country.u_region.sys_id;

})();