script working intermittently

[GreenPilgrim]

This script is working every now and then but not every time. It's pasting the date & initials but leaving off the time. It's strange because every now and again it will paste the time too, but mostly leaving off the time. I need it to paste all 3 each time.

GetAsText(Get ( CurrentDate ))& " " & Bailbond::Initials & " " & GetAsText(Get ( CurrentTime ))

Thanks in advance for any help.

[Genx]

Are you sure your field isn't just to small to accommodate the time value -- i.e. have you tried clicking into the field to see it's entire contents?

Probably not the issue, but its worth a try.

Also, why are you using get as text? If you want to format the values in a particular way, you can use the Hour, Minute, Day, Month, and Year functions on the Get(CurrentTime) and Get(CurrentDate) functions respectively.

[GreenPilgrim]

No the field is plenty long. Why "getastext"? I have no idea. I don't know what I'm doing and just guessing as I go. Could you re-write the script for me and post it here? Any help is appreciated as I do not know what I am doing.

[Genx]

.. GetAsText isn't an issue, it's just un-necessary.

I'm not sure this will help but try...

Get(CurrentDate) & " " & Bailbond::Initials & " " & Get(CurrentTime)

Otherwise (not that i think it will make a difference... ) try

Let( TS = Get(CurrentTimeStamp) ;

Date( Month(TS) ; Day(TS) ; Year(TS)) & " " & Bailbond::Initials & " " & Time( Hour(TS) ; Minute(TS) ; Seconds(TS) )

)

Finally, you shouldn't be "pasting" the value, you should be using Set Field... which i'm assuming you are doing.

Edited November 17, 2006 by Guest

[GreenPilgrim]

ok, none of these are working. The field has plenty of room in it. There must be something else I am doing wrong.

[GreenPilgrim]

p.s. I am using set field

[Genx]

Can you attach the file? You can delete all unecessary layouts/ relationships / data first.

[GreenPilgrim]

schwooom! I have no idea what you're talking about. What do you mean attach a file? Delete stuff? Sorry, but you're going to have to be more explicit with me as I am a severe novice.

[Inky Phil]

Hi Mitzi

Try this

Setfield(Yourfield;Get( CurrentDate )& " " & Bailbond::Initials & " " & Get(CurrentTime ))

Let me know how that goes

Phil

[Genx]

.. I am assuming thats what they have been doing.

Anyway, what i was saying was attach the filemaker file so we can try and work out what the problem is -- it's hard to just go on what you're telling us here because it sounds unusual

[Inky Phil]

Hi Genx

I just stripped out the get as text elements (just in case) and I was just keeping it simple, hence no explanation.

It works in a script on my machine anyway although I didn't try putting the get as text bits back in to see if it failed.

Phil

[Genx]

I'd quote myself, but i'm too lazy -- read my second post -- i did test the GetAsText() ..

This is just a general note, it really has no effect though it is a bit redundant.