#1: Random record
Posted on 2008-04-18 18:09:15 by 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
Report this message |
|
#2: Re: Random record
Posted on 2008-04-18 20:17:51 by Kevin Audleman
On Apr 18, 9:09 am, Ron Lambert <rail...@sasktel.net> 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)]
Report this message |
#3: Re: Random record
Posted on 2008-04-19 00:24:56 by The other Mike
Kevin Audleman wrote:
> On Apr 18, 9:09 am, Ron Lambert <rail...@sasktel.net> 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
Report this message |
#4: Re: Random record
Posted on 2008-04-19 16:27:58 by E W P Appeldoorn
"Michael Myett" <noone@nowhere.net> schreef in bericht
news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> Kevin Audleman wrote:
>> On Apr 18, 9:09 am, Ron Lambert <rail...@sasktel.net> 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
Report this message |
#5: Re: Random record
Posted on 2008-04-19 23:25:57 by Helpful Harry
In article <480a016b$0$54873$dbd4f001@news.wanadoo.nl>, "Ursus"
<ursus.kirk@orange.nl> wrote:
> "Michael Myett" <noone@nowhere.net> schreef in bericht
> news:Zc9Oj.3242$1a4.1199@fe73.usenetserver.com...
> > Kevin Audleman wrote:
> >> On Apr 18, 9:09 am, Ron Lambert <rail...@sasktel.net> 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)
Report this message |
#6: Re: Random record
Posted on 2008-04-20 10:36:49 by Paul Bruneau
> And be aware that truly random not exists with filemaker
>
> Keep well, Ursus
Well it's certainly random enough.
Report this message |
#7: Re: Random record
Posted on 2008-04-20 18:13:14 by Railman
Thanks, it would be random enough for me.
--
A second cup of coffee always works for me
Report this message |