Solved: Create Rule and Warning - Page 2

MM_Group · 12-27-2023 08:31 AM

Hi all.

Is it possible to trigger a warning if two columns match a condition.

My App selects parts to either Renew, Repair or Paint. The two columns in the row are:

[CODE] & [Description]

Example, If a user selects 'Renew' from [CODE] which is an Enum, and he selects 'Bumper' from [Description] again an enum. I would like a warning to the user something like...: 'You have selected a new bumper, would you like to add clips to that order' or something along those lines.

Another could be:

Example, If a user selects 'Renew' from [CODE] which is an Enum, and he selects 'Airbag' from [Description] again an enum. I would like a warning to the user something like...: 'You have selected a new Airbag, would you like to add Seatbelts to that order?' or something along those lines.

Is this possible?

MM_Group

Ok I managed a version which will work in my app, not a pop up as that should be high on the list for the developers hopefully.

Using a virtual column app formula:

IFS(

AND([Code] = "New", CONTAINS([Description], "Subframe")), "REMINDER - BOLTS, BUSHES, SGC?",
AND([Code] = "New", CONTAINS([Description], "Suspension")), "REMINDER - BOLTS, BUSHES, SGC?",
AND([Code] = "New", CONTAINS([Description], "Tyre")), "REMINDER - SGC, BALANCE, WHEEL R&R, VALVE, RESET TYRE PRESSURE MONITOR SYSTEM?",
true, ""
)

View solution in original post