i want to be able to add a timestamp with the click of a button and that that to a list, this is to have a list of everytime a member came into my gym..

for example

[color:orange]3/11/07

[color:green]3/13/07

[color:orange]3/15/07

[color:green]3/17/07

with a colored background..

i know i can do this with portals but i cant figure it out how..

all help is greatly appreciated

Edited November 18, 200718 yr by Guest

Maybe something like this?

Gym.fp7.zip

If it's always every other visit, it can be done with conditional formatting also which colorizes the date by:

Mod ( Get ( RecordNumber ) ; 2 )

... and set the condition to the alternate color you want. Or, if it is based upon odd or even dates, it can be accomplished that way as well, just by changing the formula in the conditional format.

UPDATE: Added calc if alternating by day of the date:

Mod ( Day ( date ) ; 2 )

Edited November 18, 200718 yr by Guest

yes thats exactly what i want

thank you!!

i will implement it on my database