Overview
Transform information between systems exactly how you want it. With Magical's automatic data transformation feature, you can convert dates, extract specific details, or summarize text while transferring data between apps. No more manual reformatting or data cleanup – set it up once and watch the magic happen.
Common Use Cases
Our transformation feature helps you handle various data conversion scenarios:
Date Format Conversion: Convert patient birth dates from year-date-month format in one system to date-month-year in another
Data Extraction: Pull specific information (like BMI) from longer medical notes for targeted form fields
Unit Conversion: Automatically convert measurements between different systems (e.g., height from meters to feet)
Text Summarization: Condense lengthy paragraphs into concise summaries
Step-by-Step Setup Guide
Navigate to the webpage containing your source information
Access the Magical panel and locate the pencil icon labeled "Add Site Info"
Find the site info you want to transform and click the ellipsis (⋯) menu next to it
Select "Transform" from the menu options
Enter your transformation command in the text box
Example: "Transform patient's birth date from year-date-month to date-month-year"
Click the "Transform" button and review the output
If satisfied with the results, click "Save" to store your transformation
Using Your Transformation
Once saved, your transformation will automatically apply whenever you use this site info in any automation. This ensures consistent data formatting across all your workflows without manual intervention.