Hi, I only seem to be able to find half-solutions to my questions because everything seems to be regarding AirTable.
I am trying to create an app which has a buttons for each individual day of the week. The source is a Google Sheet (Timetable).
The buttons are labelled so the user just clicks the day of the week to retrieve their required information instantly.
For this example, I am going explain my request using Wednesday as the subject.
This app is a timetable where if the user wanted to know what aircraft movements were operating on a specific day. By clicking the relevant day, ( in this case Wednesday!) The DVL will return a list of all the aircraft in the Google Sheet operating on a Wednesday.
What I am trying to do is this:
If I click on the “We” button (short for Wednesday) first of all the button would change colour to highlight and signify to the user that the day Wednesday has been chosen. (See image below:)
Now, because in aviation, Wednesday is the 3rd day of the week, the next thing I wish to happen is, within the Google Sheet I would like each "Day"button to be associated to their relevant column within the GSheet.
Eg. “We” button to be associated to “We” column (column J) in the GSheet; “Mo” button to be associated to the “Mo” column (column H) and so on. (See image below:)
The idea of this is so that each “Day” will return it’s own individual filter to the DVL.
If the user wished to select a different day within the app, he would tap on a different “Day” button. Let’s say “Mo” (for Monday). Upon clicking this button, the previously selected and highlighted Wednesday button 's colour would no longer be highlighted and Monday(Mo ) button would be highlighted instead.
There is also a “Clr” (Clear) button which I would like to use to deselect and remove the highlighting from all of the “Day” buttons and make the DVL once again invisible.
I have already created the buttons but I do not know where to start because I don’t know whether I need an individual set of blocks for each day for each filter, or could all of this be executed more succinctly.
Here are my blocks so far, I have created the “When button click” block for each individual day of the week,
Here are my blocks:
My Clear Button blocks (TimClrBtn) are shown below:
Any help would be greatly appreciated.