Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?
Self-hosted
What do you need help with?
CONFUSED WITH AUTOMATION STEPS.
IMAGINE 10 ROWS IN TABLE A - THE FIRST IS MY “HEADER” ROW (A DATAFIELD IDENTIFIES THIS)…THE OTHER 9 ARE LINE ITEMS FOR THIS HEADER (QTY, ID ETC)
ALL ROWS HAVE A DATAFIELD “STATUS”.
IN ANOTHER TABLE (TABLE B) , USERS WILL LOAD WEEKLY A LIST OF DRAWINGS - EACH UNIQUE ONE BEING THE EXACT SAME ID FOR THE PRIMARY FIELD ON ALL 10 OF MY RECORDS (THE HEADER + 9 LINES).
WHAT ARE THE AUTOMATION STEPS TO DETECT A NEW ROW IN TABLE B - THEN FIND ALL 10 RECORDS IN TABLE A WITH THE SAME ID - AND UPDATE ALL 10 RECORDS IN TABLE A WITH A NEW STATUS VALUE ?
I GET LOST WITH “ITERATION” AS ONE OF THE STEPS…TRIED LOTS OF COMBINATIONS…
THANKS ALL
Good morning, could you try something like this?
- Trigger: rows created in
tableB.
- List rows node, filtered so that it finds all records where
tableB.rows.0.IdField = tableA.IdField.
- Iteration node (iterates on the list rows results)
- Update row node (inside the iteration node), which sets your status field.
Cheers,
Peter Evans
Thanks Peter - will give it a try.
Peter sorry to be a pain - and thanks for all help…..not done Automation before.
Following your advice I kinda got this far but not hanging together (Fabricated was my Table B) - MTO is Table A.
What I am missing and Baserow documentation is obtuse on it - what is the structure and what and how are the parameters handed off ?
what am I doing wrong !!!
Very Best regards - really appreciate your help and insights.
Mike in SW London
