Hello
In a Project Management App, the structure I made is that a Project has many Objects and an Object has many Tasks.
After I enter a Project from a Deck view of Projects:
I go into a Projects_Detail View, where I have the Tasks listed and Grouped by Objects.
Now itโs really great that the Object Title, by which the Tasks are Grouped, is clickable. But the Issue is that when clicked, it takes me โฆ somewhere unexpected:
By the Title, I know itโs a Task_Detail Viewโฆand itโs empty because I got there โฆ not by clicking a task so it doesnโt know what to show (I think). I guess it goes somewhere related to a task view, as the name of the Object I click to get here, is a Grouping Name of the Tasks from the Task_Inline View.
But the question is, Can I make it take me to a Object_Detail View of that Object? (as the User would expect). Since itโs not an action button, I have no idea where to control it from, and in the Task_Inline View, I canโt find anything related.
And if itโs not possible, can I make it unclickable?
Thank you,
Sorin
(I just have to say, this forum is incredible. Itโs really alive and itโs making the Appsheet learning curve so fast. I love it and I love the app. Thank you, really)
Solved! Go to Solution.
Quick update: we have a code-fix that will disable clicking on grouped headers like this. Eventually, we may decide a separate view that will list those grouped tasks but for now it seems sensible to prevent this drill-down because the rows are already listed.
Expect to see this fixed tomorrow afternoon.
Any guess what it could be?
(I see there is a major issue going on and I guess Praveen is preatty busy with that)
Checkingโฆ what kind of table structure you have? Is the Object a child record of Project and then again Task is a child of Object? No direct relationship between Project and Task?
Hy @Aleksi
So There is a Projects Table, a Objects table and a Task table.
The Objects Table has a Ref column to the Projects table, as each object is part of on Project and one Project can have many Objects.
And the Task Table has also a Ref column to the Projects Table and an EnumList Ref column to the Objects Table, which was constructed following these instructions I got from the community:
(point was when I add a Task from within an existing Project, I would have the Object question in the form already populated with the Objects related to that Project)
Whatever it is, clicking on something shouldnโt take you to an empty view. So that is a bug. Could you please send the app name and repro details to support@appsheet.com
The data modeling is a bit non-standardโ it sounds like the same Task can reference multiple Objects within the same Project. So not too sure what it means to group Tasks by Object.
Hy,
What are the repro details and how do I get them?
Any task belongs to One Object and an Object can have many Tasks. It shouldnโt be that a Task can reference more than one Object.
(so a Project can be like - Producing the furniture of a Coworking, an Object could be Producing a table within that coworking and a Task could be Cutting the wood for the top of that table. So any Task is related to one Object and any Object is related to one Project. Also, implicitly any Task is related to one Project. So in Project Detal View, I set to view the Virtual List Column of the Tasks related to that Project, which was created automaticaly by appsheet when I referenced the Tasks with Projects and grouped that view by Objects)
In that case, why not model simply as Task has a Ref to Object, and Object has a Ref to Project.
Then it should all work cleanly.
โRepro detailsโ โ sorry I was using jargon. This just means tell us the steps to get to reproruce the problem โ which view should we click on, what should we click on next, etc. Your screenshots are very good though, so we may not need much more than that
@sorin_mihai I was thinking the same as Praveenโฆโwhy not model simply as Task has a Ref to Object, and Object has a Ref to Project.โ
So you suggest taking out the Reference between Tasks and Projects?
Well, since itโs my first app โฆ I donโt have a very frank answer I might be wrong.
But the thing is the views I created so far, are just so perfect for what I wanted when I started the App. So if you think I can reproduce them this way, sure. I made a copy of the app to try this new structure. So here are a few questions:
But if I take the ref between Tasks and Projects, how can I get this set up? I donโt get the virtual column of related Tasks List which the I can choose to be displayed in the Projects View. I canโt create a list column myself โฆ
In the deck view of the Task, I need the action button that if clicked, takes me directly to that Project view displaying all Tasks of that Project, grouped by Objects.
In the deck view of a project, I want to have a button to quickly add a Task to that project, and when opening the form, have the name of that project already filled and only the objects belonging to that Project available in the dropdown. I donโt want to go in the Project, than in an Object and then create a Task.
So really, itโs like there are Projects, that have Tasks which can be grouped by Objects. But then again, an Object view is also really handy and so, thatโs why itโs not just a column in Tasks.
I took down the Reference between Tasks and Projects and Iโm not so optimist. You think itโs just a matter of working on it?
#1&2 - You could create the same functionality with your own virtual related list column like SELECT(Tasks[KeyColumn],[Project_ID]=[_THISROW].[ID]) and then group it by โObjectsโ.
#3 - You can create that action button with the LINKTOFORM(โTasks_Formโ,โProject_IDโ,[ID]). The dropdown for the Ref field can read Objects when you type it like SELECT(Objects[KeyColumn],[Project]=[_THISROW].[Project])
Sounds like a matter of working on it and learning more formulas Iโll take it.
Iโll be back with questions if I hit some dead ends doing this chage.
Thank you @Aleksi
What do you mean by โIDโ in the last part of the formula?
So now the Tasks Table has a Objects ref Column referencing the Objects Table, and the Objects table has a Projects ref column referencing the Projects table.
The formula you suggest goes into the Projects table as a virtual column, and it wants to Select (and create a list) of the Tasks, where the Project ID is equal to the ID of the Project I just selected. But since the Tasks table does not reference the Project table, there is no Project ID in the Tasks table to equal the selected Project. However, in the Tasks table there is an Object - ID that references the Project - ID I just selected, but then the formula has to Select the Tasks (by their key column), that have the Object ID that references the selected Project ID โฆ how would that go into the formula? โฆ or am I mistaken?
As it is right now, your formula shows All Tasks listed on All Projects โฆ (I replaced [ID] with [Project - ID] as it says " Error in expression โ[Projects - ID].[ID]โ : Unable to find column โIDโ " and [Projects - ID] is the key)
Youโre welcome
When you create a task record, you would need to have the projectID with the Deref like [Oblject].[ProjectID] as well so you can read the list. I was assuming you would have it already.
Quick update: we have a code-fix that will disable clicking on grouped headers like this. Eventually, we may decide a separate view that will list those grouped tasks but for now it seems sensible to prevent this drill-down because the rows are already listed.
Expect to see this fixed tomorrow afternoon.
Great, so coming back to the Initial Posting - The Group By Title is not Clickable and so it will not lead to an empty view anymore.
What I did to still have this link to the Object View, is I added an action button to the side of it and if clicked, it will take me to the correct view of that Object.
Problem solved Thank you
Any possibility to move that action button closer to the Group By Objects Title? instead of heaving it at the end of the line?
Hi,
I used to have what you call the โObject actionโ button on my app. However, with this update that Appsheet has made, it has now disappeared!!! So can you please explain to me how you added the button? I canโt seem to figure out how to attach it to the โGroup by Objects Not Clickableโ.
Thanks,
Josh
Hi Josh,
I also added that before the change and now it is gone too. Itโs definitely related to the update to make the Group By Tile unclickable. So I donโt have an answer anymore.
What I did now is I added the button as an Inlay button to all the Tasks so I donโt go to the Object via the Group By Object anymore but I go through any Task that is Grouped By that Object.
Also the Bolding is definitely part of the Update and I like it as it gives the View of Menu and Submenu. I did that before through Format Rules but now itโs automatic so I think itโs great.
Not with the Group by when using Deck viewโฆ Though you can assign that action to your โDeckโ record.
@Aleksi Any hope to get this Action back? It would be very intuitiv to open the Parent by clicking on it.
User | Count |
---|---|
32 | |
31 | |
30 | |
18 | |
17 |