Dynamic mattress/bed Questions
-
Hi
I’m trying to create a dynamic mattress/bed and have two questions about how to do this.1, select the size of the mattress from a drop down menu and have both the X & Y dimensions change.
2, when a single is selected have one pillow in the middle and on a double have 2 at ¼ and ¾ along the bed.
If anyone knows where I can find a good tutorial on creating dynamic components it would be appreciated.
Thank you for your help.
-
-
Thanks juju
The information it will be of use to me, especially when I try a dynamic staircase.
I've managed to solve the second question, I was trying to use one component with 2 pillows but realized two components one with 2 pillows and a single pillow components with them being hidden as required.
I'm still struggling with my first question, I tried the formula below
=IF(Size= [highlight=#ff4040:wwqhhw6a]King OR Super King[/highlight:wwqhhw6a],200,190)
I didn't work and only solves the problem if there are two lengths to chose from.
Andrew
-
OR(logicalValue1,logicalValue2,...logicalValueN)
so quite likely
=IF(or(Size = "King", Size = "Super King"),200,190)
-
Hi pcmoor
Thanks for the reply your formula worked but I did have to change the descriptive values for the actual width values of the mattress size
=IF(or(Size = "150", Size = "180"),200,190)
I also now know that I cant Just stick AND & OR any where I Like I've got to put them in first.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login
Advertisement