Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

How do I display 1 row randomly using Slice but only on certain tags

In Slice > Row filter condition, i add this Expression:

 

[_RowNumber]=RANDBETWEEN(1,4300) 

 

In Virtual Column, i add this Expression:

 

floor((((([_RowNumber]+0)/decimal( floor((hour(now()-date(“12/27/1900”))+0)/0.01) ))*1000000000000) -floor((([_RowNumber]+0)/decimal( floor((hour(now()-date(“12/27/1900”))+0)/0.01) ))*1000000000000))*10000)

 

With the method above I can display 1 card randomly and it will change every few hours.

My question is, how do I only display rows from certain [tags].

For example, I only want to display [tags] = "picnic" or "mountain".

Any idea?

 

 

 
0 1 81
1 REPLY 1

Using the expression CONTAINS("[Column]", "Mountains"). Wrapping your current statement in an AND() with it.

Top Labels in this Space