SMS - Check mobile numbers for all clients for a day in Diary

SMS - Check mobile numbers for all clients for a day in Diary

In later version of 6.1 you can include letters in the mobile field and Vetlink will exclude them when sending. However you can still get an error if the mobile length is over 25 characters. Below query includes mobile length as well.
select CM."Ref_Number", CM."First_Name", CM."Last_Name",
C."Details" "Mobile", char_length(C."Details") "Mobile Length", C."Contact_Type", DM."Start", DP."Dry_Name" "Diary"
from "Diary_Main" DM
join "Client_Main" CM on CM."Ref_Number" = DM."Cln_Num"
join "Contacts" C on C."Number" = DM."Cln_Num"
join "Diary_Profile" DP on DP."Dry_Number" = DM."Dry_Num" and DP."Site_Ref" = DM."Site_Ref"
where DM."Date" = '16 Sep 2024' //Change Day here
and C."Person_Type" = 'C'
and C."Contact_Type" in (5)

    • Related Articles

    • Creating Feedback Automations

      Creating Feedback Automations Overview This article provides step-by-step instructions for setting up automation for client feedback on departed appointments, including creating automation, setting filters, creating templates, and scheduling. 1. ...

    • VetlinkPRO Basics - End of Day Videos (v6)

      Below are training videos on the basics of performing End of Day within VetlinkPRO: How to do EOD Fixing billing mistakes You can also check out the End of Day section in the Quickstart manual here;

    • VetlinkPRO Basics - Diary Videos (v6)

      Below are training videos on the basics of using the Diary within VetlinkPRO: Diary Overview Make Appointment Move Appointment Patient/Client Detail Lookup Arrive/Admit/Take Weight Confirm Appointment Print Consent Forms You can also check out the ...

    • Chapter 34 - Batch Numbers and Expiry (v7.0)

      Chapter 34 - Batch Numbers and Expiry (v7.0)

    • Chapter 35 - Batch Numbers and Expiry (v6.1)

      Chapter 35 - Batch Numbers and Expiry (v6.1)