Newbies ClooSoo Posted August 12, 2020 Newbies Share Posted August 12, 2020 (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 August 12, 2020 by ClooSoo clarification Link to comment Share on other sites More sharing options...
This topic is 1025 days old. Please don't post here. Open a new topic instead.
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
Already have an account? Sign in here.Sign In Now