Skip to main content

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 c7am, 9am]



The second problem required me to solove this first

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. 🙂

Reply


Terms & Conditions