Dropdown controls help

(1) Share

Report

Posted on by mao247

Hi Everyone,

Hope someone can help me.

I am trying to build a holiday leave tracker form that gets saved on a SP List and hoping that what I have in mind is doable.

Used and Workday Plotted dropdowns both have Yes, No, and Forfeited as choices.

I want Workday Plotted to be automatically set to "Forfeited" if Used is set to "Forfeited". Same as for "No" value. If we can also set the Workday Plotted to not be editable afterwards will be a very much desired for this as well.

I am very open to suggestions as well on how to better execute this if what I have mind cannot be done. Thanks all!

Categories:

Using Apps Using Formulas

General Questions

All responses (3)

Answers (0)

Suggested answer

mao247 on at

Like (1)

Report

Dropdown controls help

I already figured this out using the formula

If(Used.SelectedText.Value = "Forfeited", Used.SelectedText.Value, "No")
mao247 on at

Like (1)

Report

Dropdown controls help

Hi @FLMike,

Sorry if its confusing.

Update on this though, I already figured out the "Not Editable" Part by using an IF command on the DisplayMode property so please disregard that.

Now with regards to my first question, let me update it to just one parameter which is Forfeited. what I want to happen is if someone chose "Forfeited" on the "Used?" Dropdown, it will also say "Forfeited" on the 'Workday Plotted?" dropdown automatically. I tried to use the If formula

If(DataCardValue13.Selected.Value = "Forfeited", DataCardValue15.Selected.Value = "Forfeited")

but am getting an error: Incompatible types for comparison. These types can't be compared: Table, Text.

The choices for each dropdown are not just text as they are populated from the SP List via the following Choice formula.

Choices([@'HOTO Tracker'].Used)

Choices([@'HOTO Tracker'].'Workday Plotted')
Suggested answer

Michael E. Gernaey 40,331 Super User 2025 Season 1 on at

Like (1)

Report
Dropdown controls help

HI,

You didn't mention specifically if Yes should also be the same but I am going to assume yes. Also, you said Workday Plotted cannot be edited afterwards, but I dont know what that means.

Non editable after its saved? Not editable after Forfeit or No is choosen by Used? When is it editable? Also, it sounds as if technically Workday is always equal to Used, unless Yes is not... But here you go

I also don't know if these are just Texts?

1) I added a DropDown called Used

2) I added a DropDown called WorkdayPlotted

Both of them have the default Items which is the

DropDownSample collection which just has 1,2,3 in it, but it meets your needs.

Now, in the WorkdayPlotted, Default property I put

Used.SelectedText.Value

And now when I change Used it automatically makes WorkdayPlotted = to the same thing.

Now, I am still not sure, when you set WorkdayPlotted??? I mean by clicking it. If a user comes in, whats the default

value of the Used dropdown??, as it will automatically set WorkdayPlotted to that value.

So still many details missing. But thats how you make them the same

As for not editable... if they are always the same, just set its DisplayMode to Disabled. The value

will change but only based on Used dropdown.