cterrell16

I was able to make it work thanks to you. Thanks so much.

I should not have anything locked since there is only one person using the invoice system. Can you give me an example of how I would use the replace field contents method in my current script. I had tried that before but I could not mange to make it work.

I'm trying to find out how to apply a time stamp to all the open records being browsed when I run a script. Currently I search all my invoices for items that have not been payed. I then hit a button to run a script to email all open invoices. A time stamp is added to show that it has been emailed. Right now my script only applies the time stamp to the first record. All are being emailed however. Any ideas or help how I can get the time stamp for all the records being emailed. Script calculation is below: Insert Calculated Result [Select; Invoicing:: Emailed Timestamp; Get (currentHostTimeStamp)] Go to Layout ["Invprint" (invoicing)] Save Records as PDF [Restore; No dialog; "Invoice.pdf" records being browsed] Send mail {send via email client; To: customer file::invoiceconfirmemail; Subject, etc....... Go to layout [orignial layout]

Maybe a script that would apply a timestamp to all open files would work.

I created a script that emails invoices and applies a time stamp.. That worked great when used one layout page at a time. I was then asked if we could do multiple pages instead one at a time. I just had them find all the pages that they wanted to email so the script would email all that was being browsed. This method works great but it only applies the time stamp to the first page in the browsed pages. Is there a way to make the time stamp apply to all the browsed pages when emailed. I'm using filemaker 11 pro right now. The script that I'm using is below. Insert Calculated Result [Select; Invoicing:: Emailed Timestamp; Get (currentHostTimeStamp)] Go to Layout ["Invprint" (invoicing)] Save Records as PDF [Restore; No dialog; "Invoice.pdf" records being browsed] Send mail {send via email client; To: customer file::invoiceconfirmemail; Subject, etc....... Go to layout [orignial layout] Thank you for your help.

Any ideas. I don't see how this could happen during a search.

yes its working correctly. Except for when you search that field.

I have a layout that has a calculation field for my records. This calculation shows if an order is open or closed. Normally I can use the search feature and type open in that field to show all my open records. Just last week it doesn't search correctly. When I search for all the open records now it will bring up a lot of closed records and just a few open records. The calculation hasn't been changed and it works if you look at my records individually. This is my calculation. If(GetAsNumber(BALANCESHIP)=0;"CLOSED"; "OPEN")

To do that would I be creating a custom record privilege. Create Yes, view Yes, Edit no, Delete no, Field access all.

We tried only allowing the user to enter into empty fields for 3 days now. Users are making a few mistakes per day. Too bad we cant put that function on a timer. For instance you have 10 minutes to edit the field like you need it. Once that 10 minutes are up you can not edit them. The other option you mentioned was to let them create but not edit. I would think that would just allow them to make a record but not enter any data into the fields.

I'm sure they would mess up a field at some point so that would be a problem. And they have to be able to edit and create these records because it's what they do all day long. Any other ways to lock a record.

We create a record that has some information. Once everything has been entered we give it a number. Once the number has been added we would like to lock everything on that record so nothing can be changed.

Can a script be made to lock all the data on a record? I find that employees go back to look at old records but change things by accident.

Thanks, I was putting the calculation in the wrong spot. Within the custom dialog area.

I tried it a few different ways but it keeps telling me the specified table can not be found. Is it because I am using the calculation in the show custom dialog script..

this one isn't working for me. I tried a few of the examples you provided but I just get 1 , 0, blank or error. What I have is information in a special note field. I added to the print script the show custom dialog then in the message I have entered Work Order::SPECIALNOTE, this way the field data will pop up so it is hard to miss. I just don't want the dialog box to pop up when nothing is in the specialnote field. How do I make the isEmpty work in my instance.

Looks good. How can I make it only pop up when there is data in the field? Right now it will pop up even when blank.

I have added a field with special notes. When I print this record using a script I would like it to pop up this special note on the screen before it prints so the user will not miss it. Is there a way to do this?

You the man. Thanks.

I have a field that has a set point of 100. The second field is a reading we enter, in this case say 80. I want the third field to turn red if it's +/- 5% off. With 80 it should turn red. At 96 its ok, hence not red.

Can the conditional formatting be used to highlight a field when you want to show if a field is plus or minus 5%?

Thanks

I created a script that captured the time and date an email was sent via a timestamp. I now have noticed that some users will duplicate records. When they do this is copies the time stamp which defeats the purpose. Is there a way to stop that from happening?

Got it. Thank you.

In the script I've entered the set field and placed it into the script. I've got to choose calculated result or specify target field. Neither seem to work.