Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Geniuses,
I have a very strange requirement from client , what they want is that they have a comments field like below
Comments |
---|
Thank you Chetan |
14th of December 2015 was the day I reported this issue and ETS finally fixed it today on the 28th of January 2016 a month an a half is too long to fix an issue. Thanks for your support though |
Speedy and quick resolution. |
Thank you Chetan for your timely assistance. Appreciate it very much. |
Now as they want to show these comments on TV so what they want is that in one text box these comments will keep on switching after every 5 seconds. Also please dont think that they have only these 4 comments, they have 1000 of comments and keep on adding and they want to show those comments randomly in one text box.
Thanks,
S
Try this:
=Pick(Ceil(Second(Now(1))/5),
Only({<Key = {1}>} Comments),
Only({<Key = {2}>} Comments),
Only({<Key = {3}>} Comments),
Only({<Key = {4}>} Comments),
Only({<Key = {1}>} Comments),
Only({<Key = {2}>} Comments),
Only({<Key = {3}>} Comments),
Only({<Key = {4}>} Comments),
Only({<Key = {1}>} Comments),
Only({<Key = {2}>} Comments),
Only({<Key = {3}>} Comments),
Only({<Key = {4}>} Comments))
Hi,
maybe one solution might be:
=FieldValue('Comments',Mod(div(Now(),'00:00:05'),FieldValueCount('Comments'))+1)
hope this helps
regards
Marco