UI Action List

Brian Lancaster · ‎05-20-2019

I have 2 custom tables. Table 1 gets most of its data from fields that need to be field out on certain incidents and requests. It gets other data from table 2 based on a rule number field lookup after insert into table 1. If the rule number does not exist in table 2 I set a variable called has error to true on table 1. At the end of the month a user with access will go into table 2 and add the info for the missing rule number. I would then like to have a UI action on table at the list level called fix errors that will only display at the top of the list if at least one record in the list has the field has error is true. When they click on it, it will go thought each record where has error is true and re-due lookup on the record. I has able to do this at the record level with a form button but I'm not sure how do do this at the list level.

Dubz · ‎05-22-2019

Have you ticked the box(es) of the records on which you want to run the UI action? You have to tell it which records you want it to run on. Create a filtered list of records where u_has_error is true and tick the select all box then you should be able to run the UI action on all selected records.

View solution in original post

Dubz · ‎05-22-2019

I would recommend either running it in a fix script or building it into a business rule that will trigger once your guy has gone through and updated the record at the end of the month.

Brian Lancaster · ‎05-22-2019

How would a business rule know that all the rules have been added to the reference table without having to run on every insert of the reference table to verify it has all the rule number that are showing on the table that shows error.

Dubz · ‎05-22-2019

I obviously don't know how your application works but you've got a guy going through and updating the records at the end of every month, you could add a simple tick box or even base it on a custom role, and only trigger the BR when it sees that input.

Brian Lancaster · ‎05-22-2019

I will just show the user how to change the filter so he only see one with error and have him check the boxes. Its only 2 extra steps once he has updated the reference table.

ggg · ‎05-21-2019

i found that my list meets your criteria.

If ALL the records in the list do NOT meet the criteria the button does NOT show.

If at least 1 record meets the criteria, then the button does show.

I used incident and incident.state as my test table / field.