Guidance needed to set up connected field filter

Ask the Community Get Answers
1

Ok, I should be able to work this out, but I cant, so any assistance greatly appreciated.

I have a table ITEMs. It has two connected fields TYPE and STATUS.

What I want to be able to do is filter the selection field for STATUS based on TYPE. Some TYPEs have lost of possible STATUSes, so have only a few.

How this is set up is:

TYPE is connected to REF_TYPES, so that each ITEM can have 1 REF_TYPE, each REF_ITEM_TYPE can have many ITEMS.

STATUS is connected to REF_STATUS, so that each ITEM can have 1 REF_STATUS, each REF_STATUS can have many ITEMS.

REF_STATUS has a 1:N connection to REF_TYPE, so that each REF_STATUS can have many REF_TYPE.

That is the connection I was hoping to use as a filter.

BUT when I try to set up a filter on STATUS, I do not get any dynamic options at all - all i have fixed options as below. And show is all about connection to users, so no joy there either.

I was hoping for something like “REF_STATUSes connected to this Record’s TYPE”

What am I missing?

image
image435×319 12.9 KB

2

I did some first principles testing and came to a conclusion that this WORK AS EXPECTED ON AN EDIT FORM but DOESNT WORK AT ALL WITH INLINE EDITING. I’ve never really used inline editing before, and now I think I remember why. I see no way to set up the filter relationship with inline editing. Hopefully someone can prove me wrong? Is there anyone with some nifty JS that provides an inline solution for this?

3

And just to close this out, I realised why in my actual app (rather than my test setup) I couldn’t get this to work on a standard edit form - the thing I was trying to find was “show STATUSes connected to this form’s TYPE”, but I realised the form wasn’t displaying the type!. Easily fixed, and now working.

But still not working (or possible) within inline edit as far as I can see?