0

I’m working on a project which I have to import data from an Excel spreadsheet using the "Excel Importer" module. After importing, I need to perform calculations on this data before committing it to the database.     My specific questions are:   1. What’s the best approach to access and manipulate imported data before committing?   2. Is there a way to add calculation logic during the import process itself?   3. Should I create separate microflows to process the data post-import?   Details of my use case: - I’m importing into a non-persistent/temporary entity.   - I need to compute derived fields (e.g., totals, averages, percentages).   - Some calculations depend on values across multiple rows.     What I’ve tried so far: - Adding validation rules in the entity.   - Creating a post-import microflow but struggled to access all imported records at once.     Has anyone implemented something similar? Any advice or examples would be greatly appreciated!  

asked 2025-04-22

1 answers