About Wee_Chin_Lim

Wee_Chin_Lim · 04-21-2021

Hi All, I have three columns here, Objective (Enum), Verticals (EnumList) and Sub Programme (Text). If i wish to have Sub Programme to have a pre-defined result D, when Objective = A and Verticals = B and Verticals = C, is there any way for me to go ...

Wee_Chin_Lim · 03-02-2021

Hi everyone! I am trying to run an expression for a form in a Deliveries Table, there are three “Delivery Type” options, “Door Delivery”, “Pick-up at Collection Point” and “Pick-up at Store” and each delivery type will result in a different “Address”...

Wee_Chin_Lim · 04-21-2021

Thank You so much, I have learnt a great deal. If I face any other issues, I’ll drop you a message.

Wee_Chin_Lim · 04-21-2021

In this case, I thought it would work in this manner, where if it hits all 3 conditions it will be give the predefined value. But it doesnt seem to be the case.

Wee_Chin_Lim · 04-21-2021

I tried to make this in this manner, IFS( [Objective] = “Monetization”, “Test”, IN(“Creator”,[Verticals]), “Brand Jam”, IN(“Music”,[Verticals]), “Monetization Workshop” ) but something is wrong, for when i select Monetization, Sub Programme = Test. I...

Wee_Chin_Lim · 04-21-2021

I tried to integrate the solution as IFS expression, but I am unsure as to where went wrong, may I know how should the code be like?

Wee_Chin_Lim · 04-21-2021

So I’ve tried without the ANY and it works as seen in the photo here. However, based on the second screenshot below, I wish to have an expression where if I select the Objective as “Monetization”, Vertical as “Creator”, the Sub Programme will be “Bra...

My Stats

cryptochrome's Bio

Badges Wee_Chin_Lim Earned

Recent Activity

Multiple conditions to get a pre-defined result

Is it possible for the form to have a mixture of pre-defined values, and a value which a user can enter?

Re: Multiple conditions to get a pre-defined result

Re: Multiple conditions to get a pre-defined result

Re: Multiple conditions to get a pre-defined result

Re: Multiple conditions to get a pre-defined result

Re: Multiple conditions to get a pre-defined result