MDA - how to show one record according to selected previous record

(1) Share

Report

Posted on by agorkemt

Hello All,

I have a problem showing one record according to previous selected record. Let me explain it this way:

I have the shift tabel and there are 3 shifts, and operator table with 30 people recorded in it. each shift has 10 people working during the shift times.

When user selects 'shift 1' I want to show in the operator name column of the form of the table only the people working during shift 1 and when the user selects shift 3, they should see only people working during shift 3.

Anyone has a clue?

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

agorkemt 71 on at

Like (1)

Report

MDA - how to show one record according to selected previous record

I do not know if this will work on the Model Driven Apps but using this formula in the Canvas app surely works!

first in the Items property of the first dropdown, write the shifts like ["Shift1", "Shift2", "Shift3"] than to the the Items property of the second dropdown where you want the condition work, write an "If" statement like;

If (

Dropdownshifts = shift1, ["name1", "name2"],

Dropdownshifts = shift2, ["name3", "name4"]
agorkemt 71 on at

Like (0)

Report

Re: MDA - how to show one record according to selected previous record

Still looking for an answer! Anyone has a solution for this?

Thanks in advance