![Cayde_Leung Cayde_Leung](https://community.airtable.com/legacyfs/online/avatars/2X/c/c0db9cd3f31d0b30a39fb3e438e4c65e5cbecfb7.png)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 20, 2021 11:45 PM
Firstly, I got a base which said two table are linked up. One is something like
Table1
Name-Code(from table 2)-[Time]
A. Aaa. [Time]
B. Bbb. ~~
C. Ccc. ~~
D. Ddd. ~~
Table2. (7am-11pm are checkbox, Y mean ticked)
Code-7am-8am-9am-10am-…-11pm
Aaa Y.————-Y
Bbb. ———Y————Y
Ccc. Y
Ddd. ————————————- Y
I wanna the Of tables 1 able to show. The time session related with the code and it is ticked. Like Aaa would write out [7am, 9am]
The second problem required me to solove this first
![Rose_K Rose_K](https://community.airtable.com/legacyfs/online/avatars/3X/f/0/f00a17fd6f15cceb2a85f5279054b2775dcaa22b.jpeg)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Mar 29, 2021 10:49 AM
Hello and welcome @Cayde_Leung!
To make sure I understand, you are looking to setup a field on Table 1 to write out when the code times in Table 2 have checkboxes checked?
One possible way to do what you are looking to do would be to create a third table just for tracking times. I created Table 3 that just tracks hourly times slots:
Then linked each code in Table 2 to a time slot using a linked record field:
With that in place I could then go to Table 1 and create a Lookup field to display the time each code was associated with.
Here is what the Table 1 table looks like with that lookup field in place.
Let me know if that helps- or if not please let me know and we can work out a formula to return what you are looking for. :slightly_smiling_face:
![](/skins/images/75AB00B4920FD2D67A8CABF77C9DECC4/responsive_peak/images/icon_anonymous_message.png)