I am stuck trying to create a functionality where the user can assign an owner for an activity or task.
So far, I have created the following: I have created a table that contains a list of activities. I also created this dropdown with a list of potential owners.
This part is working. However, what is not working, is that I want the assigned owner to be shown on top of the dropdown once selected. I have created some textboxes with conditional formatting that should appear once there is a thing in the database that contains this row’s activitiy and owner. But instead of poping up when both conditions are met for one single entry, it pops up when both conditions are met in separate entries.
In addition to that, I would also like to see the text boxes with the assigned owners organized from left to right in the order they where selected and not like right now, where I placed them.
Hi! Could you share you’re database structure? More specifically the activity data type and the owner datatype. The answer of what to do may vary a little depending of those. Each activity has only one owner? Or can an activity have multiple owners?
Hi, thank you for the quick reply!
The activity and owner datatypes are text. One owner can have multiple activities. Right now, each entry is stored separately so that each activity can be stored multiple time but with different owners per entry.
So, from what I can understand you used a Table, right? I would use a repeating group for that, so my ideas may not be exactly correct for you. Now:
As your database is now, you just need to set the data type of the group where your Onwer text (this circle with D2) as “Strategic actions”, get your data as parent group strategic action’s and write the text as “parent group’s Strategic actions’s owner”. This should work.
But then I would like to give some database structure suggestions.
Are owners users? Or will you need any other type of data related to these owners? If so, you should have “Owner” as a data type, and on your Strategic actions, the “Onwer” would be of the "Owner data type. I would rename “Owner” as related_owner, just to make it easier to understand. It would look like this:
If you do this, you can make the group where you have the owner text (D2 circle) data type “owner” and data source “parent group’s related_owner”. The text would be “parent group’s owner name”.
Oh, and the organization: you probably just have to check your layout setting and container type If you want to order, it means that you have more than one owner per action, right? If that’s the case, you should have the “related_owner” field as a list of Owners. And to show them, you would need a repeating group. The steps would be similar to the ones I mentioned!
If you want to order, it means that you have more than one owner per action, right? If that’s the case, you should have the “related_owner” field as a list of Owners. And to show them, you would need a repeating group. The steps would be similar to the ones I mentioned!