I have about 15 users of my database and for each of them I would like to setup a favourites listing.

My initial thought was to have a hidden field so that I have a script which writes to the cell who that is a favorite for. So for instance "Anna" click make favorite and that adds here name to the favourite listing field and a found set for this can be found...great!

BUT what if more than one user wants to have the same contact as their favourite?

Any ideas? thanks!

Simon

Here's a script that will put the user's name in the field, but you will need to modify it (or create another one) to get the name out!

I can't think of any reason why you couldn't just store multiple names in the "favourite listing" field. They'd all come up on a search.

Paul

Favourite Script.zip

Well sure you could have a field with as "Anna Sarah John" etc but makes it tricky to take one etc

I just dont really want to go the route of a related file

S

simoncpage said:

My initial thought was to have a hidden field so that I have a script which writes to the cell who that is a favorite for. So for instance "Anna" click make favorite and that adds here name to the favourite listing field and a found set for this can be found...great!

BUT what if more than one user wants to have the same contact as their favourite?

Let your script add the name PLUS a carriage return (UserName & "

Here's an inelegant solution. 1 field, 1 script, no related files.

Paul

Favourite toggle.zip

Force of habitual typing! I frequently find that my "solutions" do okay, but that someone with a couple billion posts is able to do the same function with one or two well executed lines. Nobody's ever outright laughed at a solution, but it does keep a person humble.

Paul

An 'elegant' solution is one that works.

Great solution simple yet works a treat, Thanks

Made a slight change instead of using the insert text / insert calculated text (which only works if that field is on the form and is allowed entry) I used "set field" but same principle and used with an add button via listings