Skip to main content
Solved

Custom enumerations and linked values

  • Nov 19, 2024 1:02 PM UTC
  • 11 replies
  • 496 views

Forum|alt.badge.img+10

Hello,

 

I want to create 3 new fields on the master part.

Field 1 will be a list of values which I will create in an enumeration.

What I would like to do is only display the values in field 2 depending on the value selected in field 1.

Also, the values listed in field 3 depends on the values in field 2.

 

How do I go about creating the links for field 2 and field 3 please.

 

Thanks

Best answer by Alexander Heinze

​@JannetteC I have extended this sample to 5 levels.

 

The attached Word document includes the ACP plus instructions. The sample was built on the Request entity in 24.2.0 and I also imported it successfully into 24.1.4. In case you use it, can you let me know if the import worked and if the instructions were concise enough?

View original

11 replies

Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Nov 19, 2024 2:01 PM UTC

​@JannetteC there is no way in which you could achieve this as a configuration in Apps10.

I’m thinking you could create some Custom Event Actions (PL/SQL) to validate the user input in fields 2 and 3 and show some error messages to the user when trying to save the data with incorrect values based on the PL/SQL logic implemented in the event. This will not pre-filter the LoV for field 2 and 3. Users could still choose a vlue from all the values in the ennumeration.


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • Nov 19, 2024 3:14 PM UTC

I wonder if there is a way to do this with condition fields? 🤔


Forum|alt.badge.img+15

​@JannetteC Another idea that may work for you, depending on the number of values you have and the relationships between Field1, Field2, and Field3, is to build the relationship into the client values for the enumerations.  It does not prevent the user from picking certain values, but it provides a guide.

 


Forum|alt.badge.img+10

​@Marcel.Ausan is it possible to do that in AURENA? 23R1 for exemple? 


Marcel.Ausan
Ultimate Hero (Partner)
Forum|alt.badge.img+22
  • Ultimate Hero (Partner)
  • Nov 28, 2024 10:38 AM UTC

​@IFSRUNINNOVAL nope not possible in IFS Cloud neither. But I find suggestion provided by  ​@Tracy Norwillo very good for such usecases. It points the user in the right direction based on what values they might choose.


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • Nov 29, 2024 4:10 PM UTC

Hi everyone,

I have just hit upon another issue and that is the maximum characters limit.

Just wondering can I achieve what I am after by creating a CLU and the user selects what they are after from there ?.

Not sure if this is even possible  just a thought - please let me know your thoughts.

 

Thanks


Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+25

​@JannetteC did you look for something like this?

 

 


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • Dec 6, 2024 3:24 PM UTC

Hi ​@Alexander Heinze ,

What you show here is exactly what I want to do.

How are you achieving this please ?

Thanks


Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+25

Hi ​@Alexander Heinze ,

What you show here is exactly what I want to do.

How are you achieving this please ?

Thanks

I’ll put together a document next week and share it along with the ACP file. Have a good weekend!


Alexander Heinze
Ultimate Hero (Employee)
Forum|alt.badge.img+25
  • Ultimate Hero (Employee)
  • Answer
  • Dec 9, 2024 9:32 AM UTC

​@JannetteC I have extended this sample to 5 levels.

 

The attached Word document includes the ACP plus instructions. The sample was built on the Request entity in 24.2.0 and I also imported it successfully into 24.1.4. In case you use it, can you let me know if the import worked and if the instructions were concise enough?


Forum|alt.badge.img+10
  • Author
  • Hero (Customer)
  • Dec 12, 2024 2:53 PM UTC

Hi ​@Alexander Heinze 

Thanks for your response, I will work through the document and met you know.

Thanks very much.