Slushbucket - custom list collector(related list)

[scwillson]

I've been trying to build a custom application, but am having trouble finishing that part that is effectively a list collector.

The app is a very basic and simple meeting tracking app, in which part of it you can add the "Attendees" to the meeting's record. I want to behave just like the "Affected CI" related list works with the Incident form. I created two separate tables: "Meetings" and "Attendees", then setup a relation ship between them so that from the bottom of the form on the Meetings table, there is a section for Attendees. There is a "New" button that shows, but I wanted an "Edit..." button (just like the one on the Affect CI related list, which I had though it was a one-to-many global UI action button).

I have not been able to get it working to query the user table while in the slushbucket, using the Edit button I made. I actually just copied the global "Edit..." UI action.

Am I looking in the wrong direction? should this be a 'many to many' relationship since a user can be in more than one meeting?

any assistance would be much appreciated.

[Rushit Patel2 · Accepted solution]

Hi simon..

one to many relation should work...it is same like marketing event and attendee relation from marketing event app(developer site).

go to related list and right click on any header-->configure-->list control.

then there will be button called.. enable edit.

after clicking that..edit button will automaticlly come with correct functionality

i hope this helps

[scwillson]

Thanks Rushit, that's a huge help. I've been able to add the Edit button. However, now I have to figure out how to setup the relationship correctly, because now when trying to edit the members, it is empty. The only records showing are those I added using the 'new' button while I was previously testing; no other records to pic from the left column.

Makes me think that I probably took the wrong approach with the tables or that perhaps I need to build out some scripting in the Relationship. Are you familiar with that at all?

I don't want modification of the Meeting and Attendee relationship to affect the user table, which is why I was trying to store the meeting/attendee relationship on a separate table called Attendees. I just noticed that the INC and Affected CI relationship is only contained on the task_ci table, which has a reference to the Task and CI as 2 separate reference fields. I was unable to find that relation ship, to see how it is configured.

[Rushit Patel2]

hi Simon,

relationship between task and affected CI is many to many relationship and is built using Creating a Many-to-Many Relationship - ServiceNow Wiki

may b u can make one many to many relationship...

in from table field select your meeting table.

and in to table field select user table.

I hope this helps.

[scwillson]

Excellent! That did it. The m2m relationship makes it just as I wanted it.

Thanks again for the quick responses!