Select common seat no. From different shift

1ADA7543-1D09-45DA-8EAF-9A6A096754AB.png

 

I have three shift like morning ,afternoon,evening And total seat is 10. I want to create a form for registration of student . 

1.When choose any shift then only show seat no which is not assigned any other student.

2. When student select shift two or three then only show seat no which commn and yet not assigned any student.

please create a formula for both condition 

0 4 98
4 REPLIES 4

Steve
Platinum 4
Platinum 4

What have you tried so far?

A library model has been prepared in which there are 3 shifts morning, afternoon and evening.

A particular student can book any of the shifts or any two or three shifts.

  • Now if after booking seats when new student comes for booking when clicking on morning shifts all empty seats are displayed but if he wants two or three shifts the common empty seats in above are not displayed. There is problem for booking two or more common seats in different shifts.Screenshot_2022-08-13-15-08-32-05_4f4b4dc22922b128424eca33c4390726.jpgScreenshot_2022-08-13-15-08-29-23_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒโ€ƒ

    Screenshot_2022-08-13-15-08-26-37_4f4b4dc22922b128424eca33c4390726.jpgScreenshot_2022-08-13-15-08-24-15_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒโ€ƒ

    Screenshot_2022-08-13-15-08-21-44_4f4b4dc22922b128424eca33c4390726.jpgScreenshot_2022-08-13-15-08-19-28_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒ

    Screenshot_2022-08-13-15-08-16-20_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒ

    Screenshot_2022-08-13-15-08-12-92_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒ

    Screenshot_2022-08-13-15-07-57-78_4f4b4dc22922b128424eca33c4390726.jpg

    โ€ƒโ€ƒ

    Screenshot_2022-08-13-15-07-36-84_4f4b4dc22922b128424eca33c4390726.jpgScreenshot_2022-08-13-15-07-11-10_f90b96e7af3c5a594eb0c92de7fc5fe1.jpg

     

    โ€ƒโ€ƒ

please help me

please help me

Top Labels in this Space