2024-01-24 Update the Receive Once? check for Message Automations

Messages Automation:

• Data Storage Optimisation:
  • Audience id data (people/companies) is now stored in the messages table as uuid arrays (processed_people_ids and processed_companies_ids).
• Processing Efficiency:
  • Before processing, the automation checks these columns to determine the existence of the record, eliminating reliance on the logs table.
• Storage Method Evaluation:
  • Investigated the efficiency of storing data directly in the messages table by generating and comparing 500k uuids against storing in a separate table.
• Checkbox Field Renaming:
  • Renamed the "Is Receive Once?" checkbox to "Receive Once?" for clarity.
• Enhanced Processing Logic:
  • Whenever the automation executes, it exclusively considers records that have not been previously altered by the automation, provided the "Receive Once?" toggle is enabled.
  • If the automation is rerun, the system refrains from sending out the message to specific records that have already been processed.

Usage Note:

• The "Receive Once?" toggle is designed for scenarios where you intend to send a specific message only once ever to your records, like important announcements, exclusive event invitations, personal milestone celebrations etc.