Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Wanna how to achiever two things with Airtable, I am new

Topic Labels: Base design
243 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

1 Reply 1

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:
Screen Shot 2021-03-29 at 10.42.21 AM

Then linked each code in Table 2 to a time slot using a linked record field:
Screen Shot 2021-03-29 at 10.43.07 AM

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.
Screen Shot 2021-03-29 at 10.44.47 AM

Here is what the Table 1 table looks like with that lookup field in place.
Screen Shot 2021-03-29 at 10.46.01 AM

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: