Hi guys
I’m trying to set up a Cross-doc Modify Row
action, but I’m completely stuck.
I have a Doc A with Table A and a Doc B with a Table B. I want to merge the data from A & B to an Overview Doc with Table X.
When data first gets entered in Table A, I can push the data to Table X via a Cross-Doc Add Row
button in Table A. So far so good.
But now I also need a Cross-Doc Modify Row
button to push changes made to a row in Table A that was already created in Table X via the Cross-Doc Add Row
action. For that to work I need to specify which row needs to be modified in Table X.
I already added a column to Table A with it’s UID (generated via Split(thisRow+ "", "/").Last()
which i found in this forum, thanks! ). When the Cross-Doc Add Row
is executed it also sends the UID from Table A to Table X. I thought I could come up with a way to reference that UID in the Cross-Doc Modify Row
formula, but alas I can’t get it to work.
I also thought of trying to push the rowURL from Table X to Table A once the row is created in Table X via the Cross-Doc Add Row
action so I can reference that, but I can’t get that to work either.
What am I doing wrong here? Is there a way to fix the formula or is my method wrong to begin with? I’m trying to “push” changes to Table X, but maybe I should “pull” from Table A? (I don’t think so?)
I’d appreciate any pointers as I’m super confused rn.
Here’s a sample source doc:
And here’s a sample target doc: