virtual function in random results

Question

I have a virtual function in random results in a confiforms tableview and when I refresh the page give me a null result and I don't wanna this, i want to give some results in a row field in my form. ???!

(row:[entry._total.randomInt(14)] OR row:([entry._total.randomInt(14)]+[entry._total.randomInt(14)]) OR row:[entry._total.randomInt(14)]*[entry._total.randomInt(14)]) AND date:1

Alex Medved _ConfiForms_ · Answer

Probably you need to fix your configuration based on the examples I have given you earlier...

Not sure what else I can answer here....

kimiya majd · Answer

thank you

it's so helpful

but my rows aren't sorted regularly and my records in my form aren't Continuous and i don't want to have a null result but now i refresh it, i give a null in many times.

what should I do?

Alex Medved _ConfiForms_ · Answer

Here is an example of how randomInt can be used (3 variants) https://recordit.co/ujjsS8w0ca So, we set the max (as base and set it to 100 (for example)) and then set randomIn(1), so 1 is the minimum possible 3 variants: one via formula field, 2nd via the field definition rule and 3rd one is online calculation in the view (each time new value on refresh) Storage format myform

myform base=100 Embedded INLINE

base Base numberhidden

-- 1st variant

random Random ([entry.base.randomInt(1)]) formula

-- 2nd variant

random2 Random via rule number

random2=([entry.base.randomInt(1)]) Set expression

– 3rd variant

myform

random

random2

Random3 online base.randomInt(1)