Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About haani

  • Rank

Profile Information

  • Gender
    Not Telling
  1. Hi Guys, I have created a simple audit log script, just wanted to know how to add parameters to allow capture of field name, old value and new value? script is below. Show Custom Dialog [ Message: "Reason for this change/new record?"; Default Button: “OK”, Commit: “Yes”; Input #1: Clients::gChangeNote, "Change Log" ] Freeze Window Set Variable [ $ID; Value:Clients::ID ] Go to Layout [ “Audit Log” (Audit Log) ] New Record/Request Set Field [ Audit Log::ID; $ID ] Set Field [ Audit Log::ChangeLog; Clients::gChangeNote ] Set Field [ Clients::gChangeNote; "" ] Go to Layout [ ori
  2. sure thanks, got it working in the end, thanks for helping me out everyone.
  3. I think u miss understood me or I wrongly wrote it, I meant within 30 days from the invoice send date, I have it working now with the workaround I posted above, thanks for your help though, much appreciated.
  4. that doesn't work either it says 57 records found where it should only find invoices between 22/12/2013 till 21/01/2014 but I have found a workaround for it I created an invoice due date (calculation) whenever send date is entered a new due date is entered into the due date field then I changed my script to find invoice that are within 30 days of that due date
  5. doesn't work as it only finds invoices that are exactly 30 days old please see below, this is not what I am looking for, I am looking for the invoices to be found within 30 days of invoice send date, thats why I was using the other script.
  6. as you can see in the image above, the date entered in invoice send date is 26/12/2013 but is not found :s
  7. The invoice send date is indeed a date field, but if I use this script Set Field [ Invoice::Invoice send date; " = " & Get ( CurrentDate ) ≤ 30 ] it only finds invoices in range from 1/1/14 to 31/1/14
  8. for example if I select the invoice send date as 28/12/2013 if it not found as it should be because we r using less than, but if i select the invoice date as 1/1/2014 it is then found till 31/01/2014 which it shouldn't as it after 30 days from the current date. what i mean by exactly is that if I select the date as 22/12/2013 and use your script it find the invoice that is exactly 30 days less than todays date, but not in between, hope u understand what I mean.
  9. works but only finds invoices that are exactly older than 30 but not within, sorry
  10. thanks for all the help I am indeed looking for invoices older than 30 days, the trouble with using less than or less than equal to is it only shows invoices for this month and not the month before :S I also applied that script and it wasn't working properly, however using the '-' only shows invoices that are exactly 30 days old which I dont want. Ps. oh and Eos I have a status validation before the script runs, didn't show it here complicated database already have it as part of my startup script
  11. Hi, I have a field called Invoice send date, and I would like a reminder to popup within 30 days of that invoice send date field, this is what I have so far in the script and is not working as it takes current date into account. Go to Layout [ “Invoice” (Invoice) ] Enter Find Mode [ ] Set Field [ Invoice::Invoice send date; Get ( CurrentDate ) & "..." & Get ( CurrentDate ) + 30 ] Set Error Capture [ On ] Perform Find [ ] If [ Get ( FoundCount ) > 0 ] Show Custom Dialog ["Invoice Reminder"; "Invoice is overdue, please check if it has been paid"] Else Show All Records Install
  12. thanks for all your help but all I want is if one checkbox is checked then only that case is emailed to the client, I will look into getting my relationship right.
  13. thanks laretta heres my database, quote attach pdf is the script I have been playing around with, thanks again. just so you are aware when u open the database there is an onopen script that runs, its just a reminder script, it will alert of two reminders one after 3 secs and another after 20 secs. check ur pm for the database thanks
  14. thanks for your help guys, but I have tried No_Access loop script and it doesn't still it selects only the first row, heres my amended script go to portal row(select;first) loop if Case::chk box = "" Go to Layout [ “Quote View” (Consultant) ] Set Variable [ $FilePath; Value: Get ( TemporaryPath ) & "Quote " & Case::Case Number & ".pdf" ] Save Records as PDF [ Restore; Append; No Dialog; “$FilePath”; Current record ] Send Mail [ Send via E-mail Client; To: Case::Solicitor's Email; Subject: "New Quote: " & Case::Case Number & " "; Message: "Dear " & Case::Company N
  15. Hi, I am working on a database and I have just found a problem with it that I can't seem to fix, as you can see from the image, I have added a portal row to a layout which includes check boxes and I have a send email button at the bottom which runs the following script: Set Field [ Case::chk box; 1 ] Go to Layout [ “Quote View” (Consultant) ] Set Variable [ $FilePath; Value: Get ( TemporaryPath ) & "Quote " & Case::Case Number & ".pdf" ] Save Records as PDF [ File Name: “file:$FilePath”; Current record ] Send Mail [ Send via E-mail Client; To: Case::Solici
  • Create New...

Important Information

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