Jump to content

haani

Members
  • Content Count

    16
  • Joined

  • Last visited

Community Reputation

0 Neutral

About haani

  • Rank
    member

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 [ original layout ]
  2. haani

    Reminder Script

    sure thanks, got it working in the end, thanks for helping me out everyone.
  3. haani

    Reminder Script

    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. haani

    Reminder Script

    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. haani

    Reminder Script

    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. haani

    Reminder Script

    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. haani

    Reminder Script

    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. haani

    Reminder Script

    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. haani

    Reminder Script

    works but only finds invoices that are exactly older than 30 but not within, sorry
  10. haani

    Reminder Script

    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 OnTimer Script [ ] End If Install OnTimer Script [ ] any help would be much appreciated!
  12. haani

    Checkbox Problem

    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. haani

    Checkbox Problem

    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. haani

    Checkbox Problem

    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 Name & "¶¶" & "Please find the Quote attached "; Attachment: “file:$FilePath” ] Go to Layout [ “Consultant” (Consultant) ] end if go to portal row(Select;Next;Exit after last) end loop as Laretta said here are my table instances name for consultant its "Consultant" and for case its "Case" the relationship is not one to many its one to one, I have tried setting the parameter to Casenumber and tired the go to related record function in the script and it still doesn't work. just to let you know checkbox has a custom value list of "1" to make it boolean. would it help if I posted my entire database?
  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::Solicitor's Email; Subject: "New Quote: " & Case::Case Number & " "; Message: "Dear " & Case::Company Name & "¶¶" & "Please find the Quote attached "; Attachment: “file:$FilePath” ] Go to Layout [ “Consultant” (Consultant) ] now the issue is that if I select any checkbox, always the first row on the portal row is selected and then the email is sent, is there anyway I can modify the script to make it select the row where the check box is selected, I searched around and thought maybe set field would fix it, but it didn't, any help would be greatly appreciated! sorry posted this is the wrong thread, this was meant to go in managing scripts thread! Attached Thumbnails
×

Important Information

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