[SOLVED] Auto populate date/time in a field - not working???

[karmacomposer]

I can't figure out why this does not work?

It's supposed to pre-populate a field with the current date/time

Code: Select all

on preOpenCard
   put the long date into varNowDate
   set the text of field "fldDateAllottStart" to varNowDate
end preOpenCard

I am using the variable varNowDate because I need to write that variable to a database later.

I have this in the card script.

Mike

[ClipArtGuy]

Code: Select all

on preOpenCard
   put the long date into varNowDate
   put varNowDate into fld "fldDateAllottStart" 
end preOpenCard

This is working here.

[karmacomposer]

I will say that the field mentioned is part of a group of controls - could that be it? It's simply not working for me.

Mike

[ClipArtGuy]

Did you try the Put statement that I replaced your "set the text" line? If that's not working you might need to do something like :

Code: Select all

put varNowDate into fld "fldDateAllottStart" of grp "yourgroup" of cd "yourcard"

[karmacomposer]

Should I put this in the card or stack script?

So weird - it's simply not populating that field.

Yes, I did check the properties, font and color to make sure it's not set to invisible or white on white.

Mike

[ClipArtGuy]

If you want it to happen every time a card is opened, then put it into the stack script. If you want it only on one card, put it into that card's script.

[karmacomposer]

OK. Very weird - I even tried a new text box field and it still did not work.

What would be a way to get the current date and time to auto populate a field? Which control should I use?

Mike

[karmacomposer]

I got it working by attaching it to a necessary button to write to the database - not really what I wanted but it works and it's automatic.

Mike