My app’s URL: https://various-desk-3084.glideapp.io/
I’m trying to build an app to show daily reports to my clients. The worksheet has two sheets. The first sheet has one row for each date to record the day’s low and high temps, weather status, visitors, etc. The other sheet may have multiple rows for the same date, each row showing different work done for that date. The idea is to build the relationship in the first sheet that collects all the work done in the second sheet for a date - this is easy; you select date in the first sheet and then match all dates in the second sheet by selecting “match multiple”. However, when I try to create a relations button for the first sheet it says that there’s no relations column available. When I go back and de-select the “match multiple”, the column is suddenly found by the button. Any solutions for this quandary?