Jump to content

Script to add current date to field, then bring up print preview


Recommended Posts

  • Newbies
Posted (edited)

I'm customizing the pre-designed  Estimates database from Filemaker for a client and trying to modify the existing print script to add the current date to a field so they know when it was printed. 

When on a layout called PO Details, there are static infos there and there is a portal for multiple line items. Clicking on the Print PO button triggers a script that I'm trying to insert "Current Date" into a field AND open up a layout in a new window designed specifically for printing so that I can print the PO.

The problem is that the print preview window that pops up shows every line item from all records (related and unrelated to the PO I am trying to print) rather than only the one's that I want to print. It is adding the date to the correct record, however. 

Set Variable [ $id ; Value: POs Data::PO ID MATCH FIELD ]
Enter Find Mode [ pause; Off]
Go to Layout [original layout ; Animation: None]
Set Field [POs Data::PO ID MATCH FIELD ; "==" & $id]
Perform Find [ ]
Insert Current Date [Select ; POs::Date Invoiced]
Set Error Capture [On]
Freeze Window
Go to Related Record [Show only related records ; From table: "POs Data" ; Using layout: "Printable POs" (POs Data) ; New Window]
If [Get (LastError) /= 0]
Halt Script
End If
Sort Records [Restore ; With dialog: Off]
if [Get (SystemPlatform) = 3]
Freeze Window
Print [Restore: Select Your Printer ; With dialog : On]
Close Window [Current Window]
Else
Enter Preview Mode [Pause: Off]
End If

Edited by ClooSoo
clarification
Link to post
Share on other sites

I did not read your script (without seeing the context, it is rather meaningless). However, I noticed this:

42 minutes ago, ClooSoo said:

trying to modify the exiting print script to add the current date to a field so they know when it was printed. 

I believe this can be accomplished much more easily by inserting the current date symbol onto the layout - e.g.

Printed: {{CurrentDate}}

Note that this will change with every subsequent printing - unlike setting a field to the current date, which will remain stored. 

 

Edited by comment
Link to post
Share on other sites
  • Newbies
Posted (edited)
41 minutes ago, comment said:

I believe this can be accomplished much more easily by inserting the current date symbol onto the layout - e.g.


Printed: {{CurrentDate}}

 

Appreciate the response... I'm not trying to add the CurrentDate to what I'm printing out. I want to add the date printed (or at least when the print preview window pops up) to an existing field in an existing record to be used for reference later. I added more to my post in order to clarify what I'm trying to do. 

Also, my bad. I accidentally typed "exiting print script" rather than "existing print script".

Edited by ClooSoo
clarification
Link to post
Share on other sites

I am afraid I still cannot find my way in your script. It seems much more complicated than I would expect. In any case, once you have located the PO you want to print and inserted the current date into one of its fields, doing:

Go to Related Record [Show only related records ; From table: "POs Data" ; Using layout: "Printable POs" (POs Data) ; New Window]

should isolate only the POs Data records that are children of the current PO.  You say that:

1 hour ago, ClooSoo said:

The problem is that the print preview window that pops up shows every line item from all records (related and unrelated to the PO I am trying to print) rather than only the one's that I want to print.

I can think of two possible explanations:

  1. You have selected the "Match all records in current found set" option in the GTRR script step;
  2. You are not on a layout of POs when you execute the GTRR script step.


Note that:

Go to Layout [original layout ; Animation: None]

doesn't do anything if you didn't leave the original layout. And we don't know what layout you are on when you call this script.

 

Link to post
Share on other sites
  • Newbies
7 minutes ago, comment said:

Note that:


Go to Layout [original layout ; Animation: None]

 

Thank you! Simply removing this above line from my script appears to have done the trick. 

Link to post
Share on other sites
6 hours ago, ClooSoo said:

Thank you! Simply removing this above line from my script appears to have done the trick. 

Don't thank me. I said the step doesn't do anything - so removing it could not change anything. And I still believe that.

 

Link to post
Share on other sites
  • Newbies

Well, believe what you want, but removing that step indeed makes the script perform as intended. 

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.