Hello everyone! Been working on a setup and trying to figure out how to do a specific thing.
In this doc with test data https://coda.io/d/_dDAtQ16lkGN/Roster-Info_suKd2vEb in the Roster page I have a control. It is working great for tasks in the table thanks to our great community help.
What I want to have is this: when a name is selected in the Control, I want right next to or below it to show this table display, which is in the detail layout for that person:
But only for THAT person, only THIS field, in this format. If nobody is selected it should show nothing.
There is a trial setup that almost gave the right info, but not in the format I am hoping for. I was almost wondering if I need to do it as something like a card view or something?
If I get a few of these specific needs set up, I will get to cleaning the rest of the setup. Of course suggestions are always welcome, and if this works out the way I hope I am happy to share it!
Hello!
Could you elaborate what you mean by “this field”? Do you want to display the info of a single column? Or perhaps table rows that are assigned to the selected member only?
If I understood it correctly, I believe it is a matter of creating a view (not tabbed view) of the Full Schedule table that displays the information you want in the correct format and then adding to that view a filter that references the canvas control.
When the canvas control SelectSelf is blank, no rows will be displayed. If a member is selected in the canvas control, the view will filter out only the rows for that member.
1 Like
I edited your doc and just added a table view. What it does is to use the “Select Self“ control to filter the content and display it if “Select Self“ contains any rows from the target table (Full Schedule)
2 Likes
So close! The Tasks Allocated to Self isn’t quite right, not picking things up for most selections. But the right result is exactly what I wanted!
I think the new tabbed views which I am using everywhere were messing with me somehow - sometimes the new thing is awesome but you still have to remember the old thing is there lol
1 Like
I think I got it! The Tasks Allocated had been using = Select Self, it needed to be .Contains (Select Self)
Wondering if it is one step more than it needs to be? It works so I will leave it but I may play with it more. Just learning about controls, they can be so powerful!
Once again it was something fairly simple in the end. I truly appreciate everyone here!!!
1 Like
