Changing Text Formulas Based on Another Field's Value

Help Center Get Answers
1

Hello Community, reaching out for some help, please.

I have a Short Text field that contains the unique code provided by Youtube to identify videos. Then, I use a Text Formula to render a viewable/playable video. The Text Formula is this:

<div class="video-responsive"><iframe width="560" height="315" src="https://www.youtube.com/embed/{Short Text Video Code}" title="YouTube video player" allowfullscreen></iframe></div>

This works great but I have one problem. If the Short Text field is empty, I’d like to kill the text formula so nothing is rendered and the Text Formula field is blank. I would then use Page Rules to exclude it because it is empty.

A solution seems it would be something like an IF, THEN, ELSE formula but I don’t know how to do this. So IF the Short Text Video Code exists, THEN render the video, Else make it blank/empty.

Hope this makes sense and hope someone can help.

Thank you!

2

Hello Stewart,

User one more text field. And add condition if “Short Text Video Code” is blank then make this field blank otherwise fill with text formula field value.

Regards,
Sunny Singla
ssingla1985@gmail.com

3

Thank you Sunny, that sounds very promising. Can you please show me the proper syntax for that as an example? THANK YOU!!

4

Sure

image
image1368Ă—1450 118 KB

image
image1150Ă—1062 25 KB

add rules in this new text field
image
image1190Ă—1400 73.3 KB

Thanks

5

And use this new field to display video

6

Thank you so much Sunny. I will definitely try this out. Have a great day!

1 Like