topic Re: One selection should also make a another selection in a different field/table in App Development

One selection should also make a another selection in a different field/table

ShellyG — Sat, 16 Nov 2024 17:41:37 GMT

Dear all,

I need ideas on how to accomplish the following:

I have a filter, where the users can make a selection in a specific field. I want to make it in a way that when they make a selection, for example the selection is '2019' in field Year1, I want it to automatically select '2019' in Year2 field.

There is a good reason why these fields are separate and I cannot combine them so that's not an option.

Anyone has any ideas on how to do that?

Thanks!

Re: One selection should also make a another selection in a different field/table

ShellyG — Thu, 17 Dec 2020 10:56:59 GMT

In addition, the way that I imagine it working is as follows:

If there is something selected in field Year1, then select the same in field Year2...

Re: One selection should also make a another selection in a different field/table

ShellyG — Thu, 17 Dec 2020 13:51:53 GMT

Hi guys,

I managed to solve this one. In case someone needs something similar in the future - what you need to so is add in set analysis in your expression something like:

Field1=P(Field2)

If it doesn't work at first, try switching the names of the fields. 'P' is for possible values of the specific field...