JavaScript Required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Share
Explore
If name & date match -> change value
Compare
Table A
to
Table B
:
IF
a
name
in
Table A
is also in
Table B
AND
the
date
from that
name
in
Table A
is also part of the
date list
from that
name
in
Table B
THEN:
Change the
Value
in
Table A
to the
Value
from that
name
in
Table B
So in the example below, the
value
of row 5 and row 7 from
Table A
(=
@
Value A
) should change to
@
Value B
(because they are both
@
Name 1
and dates "7/3/2021" & "7/4/2021" are part of
Date list
in row 1 in
Table B
)
Table A
Table A
0
Search
Row
Date
Name
Value
1
1
7/1/2021
Name 1
Value A
2
2
7/1/2021
Name 2
Value A
3
3
7/2/2021
Name 1
Value A
4
4
7/2/2021
Name 2
Value A
5
5
7/3/2021
Name 1
Value A
6
6
7/3/2021
Name 2
Value A
7
7
7/4/2021
Name 1
Value A
8
8
7/4/2021
Name 2
Value A
There are no rows in this table
Change value
👆 this is the control where the magic should happen (for now a placeholder)
Table B
Table B
0
Search
Row
Name
Start Date
End Date
Date list
Value
1
1
Name 1
7/3/2021
7/6/2021
7/3/2021
7/4/2021
7/5/2021
7/6/2021
Value B
There are no rows in this table
FYI: column
Date list
= a list of all dates between
Start Date
and
End Date
Name select list
Name select list
0
Name
1
Name 1
2
Name 2
3
Name 3
There are no rows in this table
Value select list
Value select list
0
Value
1
Value A
2
Value B
3
Value C
There are no rows in this table
Related Docs
$10k Work: How to increase your productivity using the magic of leverage
Khe Hy
Two-way writeups: Coda’s secret to shipping fast
Lane Shackleton
Peloton Analytics Tool for Workout Stats [+Template]
Al Chen
Mental Health Awareness Month
Jamie Forseth
Four Myths of Bundling
Shishir Mehrotra
OTF Planner (otfplanner.com)
Kenny
Random Quote Generator
Mark Davis
SpotRacer Database
kev null
Founders Mindset Bootcamp Shared
Nathalie Rafeh
1:1 & Career Development Template
Eric Glick
The Inbox-Zero Challenge: How long can you keep up your streak?
Shishir Mehrotra
Hiring List Template
SiNing Chan
BlockSplit Info
Block Split
Easy RSVP Tracker with the Gmail Pack
Kay Diaz-Ferrigno
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
Ctrl
P
) instead.