most recently viewed records

[Colm Osiris-3]

Hi Experts

I have a client using FMP9, who has a database which is pretty much a  
card system. There's a record for each contact. He does a find on the  
name so he can phone them.

He wants to know whether it's possible to see at a glance the most  
recent, say 10, records viewed.

With FMP10, I said he could use Script Triggers to set a timestamp  
when the record is viewed, and then sort on that timestamp. But I  
couldn't think of a way to do it in 9.

Does anyone have any thoughts on how this might be achieved?

Thanks.

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Brent Lewis]

Colm,

As you visit them, store each of the layout manes or numbers in a global field (using concatenation), then use the GetValue function to select the last one (or any other on the list), and use a go to layout step using that value.

Brent
 
Brent Lewis
Interactive Systems, Inc.
Member FileMaker Business Alliance
"Enhancing human capabilities through the interaction of people and technology"
www.interactivesystemsinc.com




________________________________
From: Colm Osiris <[hidden email]>
To: [hidden email]
Sent: Tuesday, June 23, 2009 2:21:59 PM
Subject: most recently viewed records

Hi Experts

I have a client using FMP9, who has a database which is pretty much a card system. There's a record for each contact. He does a find on the name so he can phone them.

He wants to know whether it's possible to see at a glance the most recent, say 10, records viewed.

With FMP10, I said he could use Script Triggers to set a timestamp when the record is viewed, and then sort on that timestamp. But I couldn't think of a way to do it in 9.

Does anyone have any thoughts on how this might be achieved?

Thanks.

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[White Craig]

Is it possible to use an UNC path in a custom function returning to a
container field?  The function below works perfectly from the local C
drive.  I want to move the photos to a network location that allows
others to access them and in a location where they are updated as new
staff is hired rather than on a local drive. Working with FM 9 and
Windows XP.

Here is the function that does work.
"image:/C:/StaffPhoto/" & ID & ".jpg"

Here is the function that does not work.
"image:/servername/sharename" & ID & ".jpg"
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[FM Talk]

Is it a typo or you are missing a forward slash "/" after sharename  
in the server function.

For most precise path put an image where all the images gonna be  
stored, make a new script and add command "insert picture", then go  
to add file button, and when it asks you for the pic file, point it  
to the server based image. That will automatically bring the path you  
need to use in your function in the box of that dialog box. From here  
just change the pic name to your UID$ ".jpg" and use it in your  
function.
You can delete the script, it was just to bring you the most precise  
filepath.



Your frequent FM talker:
Pavle Ancevski Pajo
New York Hotel Trades Council
[hidden email]




On Jun 23, 2009, at 2:51 PM, White Craig wrote:

> Is it possible to use an UNC path in a custom function returning to a
> container field?  The function below works perfectly from the local C
> drive.  I want to move the photos to a network location that allows
> others to access them and in a location where they are updated as new
> staff is hired rather than on a local drive. Working with FM 9 and
> Windows XP.
>
> Here is the function that does work.
> "image:/C:/StaffPhoto/" & ID & ".jpg"
>
> Here is the function that does not work.
> "image:/servername/sharename" & ID & ".jpg"
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Colm Osiris-3]

Thanks very much Brent.

> As you visit them, store each of the layout manes or numbers in a  
> global field (using concatenation), then use the GetValue function  
> to select the last one (or any other on the list), and use a go to  
> layout step using that value.

It would be the record number I would need to store, not the layout  
number, surely? But I get the general idea, and I will suggest it to  
him.

Cheers

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[White Craig]

Perhaps a typo.  I will make the change and see if it works.  The other
works perfectly, but I want to use an unmapped network location if
possible.

Craig
 
 
 
-----Original Message-----
From: [hidden email]
[mailto:[hidden email]] On Behalf Of FM Talk
Sent: Tuesday, June 23, 2009 3:33 PM
To: [hidden email]
Subject: Re: UNC path in a custom function

Is it a typo or you are missing a forward slash "/" after sharename  
in the server function.

For most precise path put an image where all the images gonna be  
stored, make a new script and add command "insert picture", then go  
to add file button, and when it asks you for the pic file, point it  
to the server based image. That will automatically bring the path you  
need to use in your function in the box of that dialog box. From here  
just change the pic name to your UID$ ".jpg" and use it in your  
function.
You can delete the script, it was just to bring you the most precise  
filepath.



Your frequent FM talker:
Pavle Ancevski Pajo
New York Hotel Trades Council
[hidden email]




On Jun 23, 2009, at 2:51 PM, White Craig wrote:

> Is it possible to use an UNC path in a custom function returning to a
> container field?  The function below works perfectly from the local C
> drive.  I want to move the photos to a network location that allows
> others to access them and in a location where they are updated as new
> staff is hired rather than on a local drive. Working with FM 9 and
> Windows XP.
>
> Here is the function that does work.
> "image:/C:/StaffPhoto/" & ID & ".jpg"
>
> Here is the function that does not work.
> "image:/servername/sharename" & ID & ".jpg"
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Brent Lewis]

Sorry Colm, apparently my reading of your question was about as accurate as my editing of the response (layout "manes"?).  However, as you discerned, the technique may be applied under several circumstances.

You might also want to add a relationship using the global field to display all related records.  This would give you the option of displaying a list of all records that were saved in the global field.

Brent




________________________________
From: Colm Osiris <[hidden email]>
To: [hidden email]
Sent: Wednesday, June 24, 2009 4:17:00 AM
Subject: Re: most recently viewed records

Thanks very much Brent.

> As you visit them, store each of the layout manes or numbers in a global field (using concatenation), then use the GetValue function to select the last one (or any other on the list), and use a go to layout step using that value.

It would be the record number I would need to store, not the layout number, surely? But I get the general idea, and I will suggest it to him.

Cheers

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Corn Walker]

On Jun 23, 2009, at 2:21 PM, Colm Osiris wrote:

> Hi Experts
>
> I have a client using FMP9, who has a database which is pretty much  
> a card system. There's a record for each contact. He does a find on  
> the name so he can phone them.
>
> He wants to know whether it's possible to see at a glance the most  
> recent, say 10, records viewed.
>
> With FMP10, I said he could use Script Triggers to set a timestamp  
> when the record is viewed, and then sort on that timestamp. But I  
> couldn't think of a way to do it in 9.
>
> Does anyone have any thoughts on how this might be achieved?

You don't need to go that far, all you need to do is capture the ID's  
of the records as you view them. This can be accomplished by any  
object/action that can fire the calculation engine on record display,  
including unstored calculation fields, record level access (if not  
using a [Full Access] account), and the web viewer.

For example, you can place an unstored field on a layout with the  
following calculation:

Let ( $$lastViewedRecordsList = LeftValues ( Case ( IsEmpty  
( FilterValues ( $$lastViewedRecordsList; YourPrimaryKey ) );  
YourPrimaryKey & ¶ ) & $$lastViewedRecordsList; 10 ); "" )

This will place the IDs of the last ten visited records into the  
global variable $$lastViewedRecordsList. You can then use this  
variable as the basis for a Find operation or, via an unstored  
calculation field, in a relationship to show those records in a portal.

This is a simple example - other requirements may necessitate a  
different approach.

Cheers,
-corn


Corn Walker
The Proof Group
http://proofgroup.com/

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Colm Osiris-3]

Thanks Brent.

> Sorry Colm, apparently my reading of your question was about as  
> accurate as my editing of the response (layout "manes"?).  However,  
> as you discerned, the technique may be applied under several  
> circumstances.

No problem, I was able to read between the lines!

> You might also want to add a relationship using the global field to  
> display all related records.  This would give you the option of  
> displaying a list of all records that were saved in the global field.

That's a good thought, thanks.

I won't be actually looking at this until the weekend, as it's not a  
paid job, but an hour or so's favour, for which I'm hoping to get a  
big bag of coffee, as the guy I'm doing it for is a coffee importer.

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Colm Osiris-3]

Thanks Corn.

> You don't need to go that far, all you need to do is capture the  
> ID's of the records as you view them. This can be accomplished by  
> any object/action that can fire the calculation engine on record  
> display, including unstored calculation fields, record level access  
> (if not using a [Full Access] account), and the web viewer.
>
> For example, you can place an unstored field on a layout with the  
> following calculation:
>
> Let ( $$lastViewedRecordsList = LeftValues ( Case ( IsEmpty  
> ( FilterValues ( $$lastViewedRecordsList; YourPrimaryKey ) );  
> YourPrimaryKey & ¶ ) & $$lastViewedRecordsList; 10 ); "" )
>
> This will place the IDs of the last ten visited records into the  
> global variable $$lastViewedRecordsList. You can then use this  
> variable as the basis for a Find operation or, via an unstored  
> calculation field, in a relationship to show those records in a  
> portal.
>
> This is a simple example - other requirements may necessitate a  
> different approach.

Hmm, unfortunately I've been thrown back into the Dark Ages - he's  
using FileMaker 5, not 9 as I thought. So sadly, no variables, no Let  
function, and no web viewer! :-(

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Patrick Neame-2]

For that I reckon you'd want a big bag of coffee and a big box of  
chocolate!

On Jun 25, 2009, at 5:08 pm, Colm Osiris wrote:

> Thanks Corn.
>
>> You don't need to go that far, all you need to do is capture the  
>> ID's of the records as you view them. This can be accomplished by  
>> any object/action that can fire the calculation engine on record  
>> display, including unstored calculation fields, record level access  
>> (if not using a [Full Access] account), and the web viewer.
>>
>> For example, you can place an unstored field on a layout with the  
>> following calculation:
>>
>> Let ( $$lastViewedRecordsList = LeftValues ( Case ( IsEmpty  
>> ( FilterValues ( $$lastViewedRecordsList; YourPrimaryKey ) );  
>> YourPrimaryKey & ¶ ) & $$lastViewedRecordsList; 10 ); "" )
>>
>> This will place the IDs of the last ten visited records into the  
>> global variable $$lastViewedRecordsList. You can then use this  
>> variable as the basis for a Find operation or, via an unstored  
>> calculation field, in a relationship to show those records in a  
>> portal.
>>
>> This is a simple example - other requirements may necessitate a  
>> different approach.
>
> Hmm, unfortunately I've been thrown back into the Dark Ages - he's  
> using FileMaker 5, not 9 as I thought. So sadly, no variables, no  
> Let function, and no web viewer! :-(
>
> Colm
> _______________________________________________
> FMPexperts mailing list
> [hidden email]
> http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au

[Colm Osiris-3]

Patrick

> For that I reckon you'd want a big bag of coffee and a big box of  
> chocolate!

I'm hoping for some chocolate covered roasted coffee beans, which are  
not easy to find, but are pretty wonderful!

Colm
_______________________________________________
FMPexperts mailing list
[hidden email]
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au