Setfield problem

[orbitNZ]

Hey,

Ive made an invoice program for my dads friends bussiness and it has a button that when clicked it displays "PAID" in big bold red font over the invoice details (and it dissapears when clicked again). Now thats all fine but my question is: How do i make its so it says Paid on: (the date the button was clicked)?

Not the date that the record was created.

I have this script so far: If(IsEmpty(_ispaid), "Paid", ""). under a setField action.

Thanks

[BobWeaver]

Try this:

If(IsEmpty(_ispaid), "Paid on "&Get(CurrentDate), "")

[orbitNZ]

Ok thanks that looks promising. But when i click ok to save the script it says: Either an operation was omitted, this function cannot be fount, or "(" was not expected here. and it highlights the word Get.

This is when i click ok for specifing the field calculation for SetField

[BobWeaver]

Are you using version 7? I notice that you were using commas instead of semicolons between parameters which is a version 6 convention. If version 6, then you would use Status(CurrentDate) instead of Get(CurrentDate). Otherwise, make sure that your opening and closing quotes and parentheses match up.

[orbitNZ]

Thanks, its working now that ive changed it to status..... well sort of.

When i clicked the paid buton it said: Paid on 732057.

Is that the date in a special format or something?

p.s Im using FileMaker pro 6

[Lee Smith]

Change the Result of the Calulation to Date, it's showing as a number now. The Default for Calculations. -Just go into the Calculation Box, and at the bottom there is a Pull Down Menu with "Number" in it now.

HTH

Lee

[orbitNZ]

hey Lee thanks for the reply but its actually a text field. And the calculation is in a script under the setfield command. So there is know pull down menu under setfield to change to date .

[orbitNZ]

hey Lee thanks for the reply but its actually a text field. And the calculation is in a script under the setfield command. So there is know pull down menu under setfield to change to date .

It also says when you click specify for setfield it says it must return text.

Thanks

[Lee Smith]

I don't have v7 (it's on the way), so I can't be sure if there are easier ways in it than in previous versions.

In v6, you would need to use the Script Step" Insert Calculated Result" and one of the Date Function.

HTH

Lee

[orbitNZ]

ok. Im actually using version 6 so could you please elaborate?

[Lee Smith]

Post your script and well see if we can make it work

[orbitNZ]

OK ive upload the file, but I have deleted all current records the database had (for privacy)

I have created one test record under Option 1. So just click the view all button then click unpaid too get to it.

Once you are at the record there should be a button down the botton called "Paid" when you click it it toggles the Paid on: (date) text acrosss the screen. The script for this is called isPaid in the scripts menu, this is the one I need help with.

The file has been uploaded to: http://orbit.corruptspace.com/invoice-copy.fp5 if you cannot download it from there you may have to goto http://orbit.corruptspace.com/invoice-copy.fp5 and click save target as or download linked file from your browser

Thanks

[comment]

Try expanding the field a bit, or reducing the font size, so that you can see the entire field contents.

[BobWeaver]

Try changing to this:

If(IsEmpty(_ispaid), "Paid on "&DateToText(Status(CurrentDate)), "")

[orbitNZ]

YAY it works thanks so much!