Database counters
Track, count and run reports on data via ThinkAutomation. ThinkAutomation offers 24/7 monitoring of connected systems, with new data pulled and processed every minute, and subsequent automations ran in split seconds. As part of this, you can automate workflows based on database counters.
Database counters – overview
- ThinkAutomation can track and update database counters, then return updated values to a variable for subsequent automations
- It can maintain counters per day, day of week, month, year, or static
- You can increment, decrement, get or set a counter
- Any arbitrary data can be counted. For example:
- Messages by day of week
- Messages by email address per month
- Messages by any extracted field or variable values (payment types, currencies etc) by day, month, year or total
- Orders by company name per year
- Outgoing emails sent by email address per month
- You can view (and clear) counters using the ThinkAutomation studio
Database counters – use cases
- Track service volume caps, then send triggered emails to customers when a limit is reached (or about to be reached)
- Track the volume of outbound sales emails against the number of replies and push the data into a BI system for reporting
- Monitor disc utilisation and send IT alerts via a triggered Teams message
- Monitor reads per second to ensure optimum performance
- Pull sentiment reports against inbound emails based on keywords identified
- Plus countless more, depending on your desired use case
- Backup emails
- Email attachment storage
- Email parsing
- Email sentiment analysis
- Email to cloud
- Email to CRM
- Email to CSV
- Email to database
- Email to spreadsheet
- Email translation
- Move email attachment to folder automatically
- Outlook export all emails
- Parse email attachment
- Translate attachment
Database
- Data ETL
- Database automation
- Database counters
- Database monitoring
- Mongo update
- SQL to Excel
- Translate database
- Update a database
Telephony
CRM
- CRM data entry
- CRM sentiment analysis
- Dynamics automation
- Salesforce automation
- SugarCRM automation
- Zoho automation
Automation actions
- Automatic compression
- Automatic encryption
- Automatic translation
- Create hash file
- Database lookup
- Date operation
- Detect language
- Execute PowerShell
- Execute script
- Extract field
- File operation
- FTP download
- FTP upload
- GeoIP lookup
- MongoDB lookup
- OAuth sign-in
- Process files
- Run a program
- Send Teams message
- Sentiment score
- Set variable
- Speak text
- SQL command to update data in a database
- SQL execute command
- String operation
- Summarise text
- Train sentiment analysis model
Product
- .NET scripting
- Automation gateway
- Automation IDE
- Automation studio
- C# scripting
- Continuous processing
- Design actions
- High speed automation
- HTTP API
- JSON parser
- Local automation
- Markdown support
- Message store
- Public web API
- RPA community
- RPA designer
- SendGrid mail server
- Text summariser
- Visual Studio code paste without formatting