Bring AnyDB reference data into CommCare lookup tables
Keep a clear path from organized reference data in AnyDB to lookup tables in CommCare with a scheduled Notis automation.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Create Lookup Table
Create a lookup table in a domain.
Why this helps
Reference data can be ready in one system while someone still has to set up a corresponding structure in another.
- Reduce manual setup for reference data structures.
- Use a recurring schedule to initiate the workflow.
- Keep run reports available for checking the outcome.
Setup
Build it in a few focused steps.
- 1Connect AnyDB and CommCare once in the Notis portal.
- 2Create an automation and describe which available reference data should be used to create a CommCare lookup table.
- 3Pick a Notis schedule that matches when the setup should run.
- 4Choose where run reports should go.
- 5Test with one real reference data example and verify the lookup table in CommCare.
Questions about this workflow
Will this update an existing lookup table?
The listed action creates a new lookup table. Describe the intended behavior clearly and verify that the table does not already exist before running.
What permission is needed?
Creating a lookup table in a CommCare domain requires Edit Apps permission.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link AnyDB to CommCare. A trigger fires from one place; an action lands in another.
AnyDB triggers
CommCare actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Lookup Table
Create a lookup table in a domain.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Web User Invitation
Create an invitation for a new web user.
List Reports
List reports configured in a project.
Single Sign On
Validate a user’s login and retrieve their profile.
Submit Form ODK Compatible
Submit form data using an ODK-compatible endpoint.
Submit Form to Application
Submits an XForm to a specified CommCare application.
Connect any two apps with Notis in the middle.
AnyDB and CommCare, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business CommCare.