Random record

Random record

am 18.04.2008 18:09:15 von Railman

I'm in need of a way to choose a random record from a file. The way I
have it set up is that I need to select a random record from a external
file if a button is pushed. I have a file made up of 120 possible
tasks (records). In a related file I need the option to pick a random
task(record) from that file and display it in the related file. Any
suggestions
--
A second cup of coffee always works for me

Re: Random record

am 18.04.2008 20:17:51 von Kevin Audleman

On Apr 18, 9:09 am, Ron Lambert wrote:
> I'm in need of a way to choose a random record from a file. The way I
> have it set up is that I need to select a random record from a external
> file if a button is pushed. I have a file made up of 120 possible
> tasks (records). In a related file I need the option to pick a random
> task(record) from that file and display it in the related file. Any
> suggestions
> --
> A second cup of coffee always works for me

Go to Record [ Floor(Random * 120)]

Re: Random record

am 19.04.2008 00:24:56 von The other Mike

Kevin Audleman wrote:
> On Apr 18, 9:09 am, Ron Lambert wrote:
>> I'm in need of a way to choose a random record from a file. The way I
>> have it set up is that I need to select a random record from a external
>> file if a button is pushed. I have a file made up of 120 possible
>> tasks (records). In a related file I need the option to pick a random
>> task(record) from that file and display it in the related file. Any
>> suggestions
>> --
>> A second cup of coffee always works for me
>
> Go to Record [ Floor(Random * 120)]

I would try Go to Record [ Floor(Random * 120)+1] to get the correct
range (1-120).

Mike M

Re: Random record

am 19.04.2008 16:27:58 von E W P Appeldoorn

"Michael Myett" schreef in bericht
news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> Kevin Audleman wrote:
>> On Apr 18, 9:09 am, Ron Lambert wrote:
>>> I'm in need of a way to choose a random record from a file. The way I
>>> have it set up is that I need to select a random record from a external
>>> file if a button is pushed. I have a file made up of 120 possible
>>> tasks (records). In a related file I need the option to pick a random
>>> task(record) from that file and display it in the related file. Any
>>> suggestions
>>> --
>>> A second cup of coffee always works for me
>>
>> Go to Record [ Floor(Random * 120)]
>
> I would try Go to Record [ Floor(Random * 120)+1] to get the correct range
> (1-120).
>
> Mike M
>

And be aware that truly random not exists with filemaker

Keep well, Ursus

Re: Random record

am 19.04.2008 23:25:57 von Helpful Harry

In article <480a016b$0$54873$dbd4f001@news.wanadoo.nl>, "Ursus"
wrote:

> "Michael Myett" schreef in bericht
> news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> > Kevin Audleman wrote:
> >> On Apr 18, 9:09 am, Ron Lambert wrote:
> >>> I'm in need of a way to choose a random record from a file. The way I
> >>> have it set up is that I need to select a random record from a external
> >>> file if a button is pushed. I have a file made up of 120 possible
> >>> tasks (records). In a related file I need the option to pick a random
> >>> task(record) from that file and display it in the related file. Any
> >>> suggestions
> >>> --
> >>> A second cup of coffee always works for me
> >>
> >> Go to Record [ Floor(Random * 120)]
> >
> > I would try Go to Record [ Floor(Random * 120)+1] to get the correct range
> > (1-120).
> >
> > Mike M
> >
>
> And be aware that truly random not exists with filemaker

It's not reallt a FileMaker fault though - truly random numbers don't
exist on computers in any software.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)

Re: Random record

am 20.04.2008 10:36:49 von Paul Bruneau

> And be aware that truly random not exists with filemaker
>
> Keep well, Ursus

Well it's certainly random enough.

Re: Random record

am 20.04.2008 18:13:14 von Railman

Thanks, it would be random enough for me.
--
A second cup of coffee always works for me