I’m working on a page that includes two tables:
- Module 1 (called CRM Table): Dimensioned by L4 Employees, includes line items like Term Date, Role, and Department.
- Module 2 (New Hire Table): Dimensioned by L4 New Hires, with similar fields.
Both L4 Employees and L4 New Hires roll up to L3 Department in the same hierarchy.
What the client wants:
- A user opens a UX form and clicks a button to create a new L4 New Hire ID in Module 2.
- As soon as the ID is created, the form should automatically populate key fields (like L4 Employee ID, Term Date, Role, Department) by referencing an employee in Module 1 — usually the most recently terminated one.
- Module 2 includes a column for L4 Employee ID, and users currently manually paste the l4 employee ID and the other lines from Module 1 into this field
This process gets tedious and time-consuming, and they want to eliminate the manual step entirely by making it dynamic through the UX form.
- I tried creating an import action to bring data from Module 1 into Module 2. The idea was to prefill key fields (like L4 Employee IDs, Role, Department, and Term Date).
- The issue: Module 1 and Module 2 have different dimensions — Module 1 is dimensioned by L4 Employees, while Module 2 is dimensioned by L4 New Hires. Even though they share similar column structures, the mismatch in dimensions makes a direct import action ineffective.
Any suggestions? thanks in advance!