UI Action List

[Brian Lancaster]

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]

You should be able to add a list choice UI action with the condition current.u_has_error == true so it will only be selectable when that condition is met.

You'll have to tick the box of the rows you want to run the rule on but you can run your lookup in the script section and it should run on every record selected.

[Brian Lancaster]

I tried that.  If I put current.u_has_error == true it never shows.  I'm guessing because it does not know to look at all records.  When I click on the UI action after removing the condition it says no records selected.

[Dubz · Accepted solution]

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.

[Brian Lancaster]

Yes I was hoping to avoid that step.  Also I noticed that If I only check on even thought I did a query in my UI that should have gone thought all the records it seems to ignore it and just do the one that was checked.