NickO

@CoopperBackpack and @NiceDuck thanks for the replies and sorry for the delayed response. I had to dip out for a few days and am sort of back now. Long story short, no unique fields or formula fields. Nothing out of the ordinary from what I can tell. All that said, I started a new triggered action from scratch, exact same as the others (using the WHERE clause to ID which records to trigger the email alert as CoopperBackback suggested) and it works fine. IDK why the other one was choking, but it's good to go now.

Hi @CoopperBackpack, thanks for the suggestion. This does clear the error in the Triggered Actions builder, but I get a much less helpful "Record cannot be saved because an error was encountered in Triggered Actions." I stripped it down to just the email (changing the message to a generic text for testing). I am not sure if it makes a difference because the #inserted should deal only with the record being inserted, but this is a pretty big table the record is being added to. I also tried to add the "Top 1" condition to the select statement at the top and got the same error. Wish it was more descript about what is failing. I also tested it with Marketing Produced set to unchecked/false to see if it would just add that record. I got the same error.

I am trying to create a triggered action with notifies a group of users in the AuthUsers table when the record meets certain criteria. I use it successfully in other tables but it is choking here for some reason and saying it expects a single value. Any thoughts on why or how to get around that? I have trimmed down just the relevant code (hopefully) to save space as it has a lot of variables for populating the email message. As a reference, I use something very similar, just without the If/Then in another table and it runs without issue.

If anyone else runs into this, I came up with a solution. It's a little cludgey, but it is functional. I added a calculated field to my table which concatenates the two IDs together, then did a comparison to those values before adding a new record with the triggered action.

I have the action below which adds relationship records between Description and Category tables when a user selects to "Add All". What I can't figure out, or find, for the life of me is how to add logic to this that would either skip the join if the record pair already exists or delete duplicates after adding all of the associations. The problem I have is that if some of the associations already exist and a user chooses to "Add All" then it creates duplicates for those that already exists. This causes problems in views and data pages.

Late thank you @Vitalikssssss. For some reason I didn't get notified of your reply. I will work with this some after I get through the current iteration and see what I can come up with. At first blush this looks very similar to what I am trying to do. I appreciate it.

@Vitalikssssss Hopefully the info below clarifies a little. The first is a screenshot of the report with no criteria selected (and the JS to hide empty rows disabled). The second is a report with criteria selected. I am currently able to hide rows in the "Solution Name" column based on criteria in hidden rows in the datapage. I would like to be able to hide rows at the Category Name and Product level conditionally based on the associated aggregate value (hiding it with CSS in second screenshot so it only shows aggregate at the product level, but it's there).

Apologies for the late reply @Vitalikssssss ... I am not sure how I missed this one. I have successfully hidden individual rows in the datapage where the value is zero, but the groups still show up. So, to illustrate. Instead of Group 1 Agg 1 Name 1.1 Calc 1 Calc2 Calc 3 Name 1.2 Calc 1 Calc2 Calc 3 Group 2 Agg 1 Name 2.1 Calc 1 Calc2 Calc 3 Name 2.2 Calc 1 Calc2 Calc 3 I have Group 1 Agg 1 Group 2 Agg 1 I am trying to hide those aggregate lines of the datapage as well. Even with collapsible groups, it still shows the "group" level even if the individual rows are not visible. If there were a way to hide the aggregate row based on the value of the aggregate, I would be golden.

Thanks @Vitalikssssss, brain freeze on my part. I ended up doing it differently for my solution, but your suggestion was correct for that approach.

I have a datapage which make about 14 different calculations to get to a list of calculated fields. I am trying to take any row in which there is a "2" and display "Primary" in this row. Each of the calc fields contains the value of blank (perhaps NULL? it is a query that is returning no results), 0, 1 or 2. Below is my case statement that is not playing nice. I appreciate any input. CASE WHEN [@calcfield:3] = 2 THEN 'PRIMARY' WHEN [@calcfield:4] = 2 THEN 'PRIMARY' WHEN [@calcfield:5] = 2 THEN 'PRIMARY' WHEN [@calcfield:6] = 2 THEN 'PRIMARY' WHEN [@calcfield:7] = 2 THEN 'PRIMARY' WHEN [@calcfield:8] = 2 THEN 'PRIMARY' WHEN [@calcfield:9] = 2 THEN 'PRIMARY' WHEN [@calcfield:10] = 2 THEN 'PRIMARY' WHEN [@calcfield:11] = 2 THEN 'PRIMARY' WHEN [@calcfield:12] = 2 THEN 'PRIMARY' WHEN [@calcfield:13] = 2 THEN 'PRIMARY' WHEN [@calcfield:14] = 2 THEN 'PRIMARY' WHEN [@calcfield:15] = 2 THEN 'PRIMARY' WHEN [@calcfield:16] = 2 THEN 'PRIMARY' WHEN [@calcfield:17] = 2 THEN 'PRIMARY' ELSE 'NOT' END

Anybody have any ideas on this one? I'm open to alternative approaches as long as I can get to the same net result.

I am not sure I follow @Corpcatalog. On my datapage, I have a column that does a custom calculation to count the number of users in various categories. I aggregate that number in the datapage and need to pass that aggregated value. Maybe I am just being dense, but I cannot find a solution that aggregates the value in a parameter that I can pass to another datapage.

I have two data pages, one to calculate which applications are need and one to calculate the number of users per application. The output to the user needs to be a report of users per application. Due to elements involved in calculating these two values, it is extremely inefficient to create a single view that has all that info. Is there a way to pass the data from the aggregate row of a datapage as a parameter? I could then use a third page to calculate the results. I am not married to that approach, by the way, that is just where my brain is locked at the moment. I am more than willing to consider alternative approaches to make this happen.

I have a tabular datapage which essentially has the columns of Group, Name, Calc 1, Calc 2, Calc 3 and an Aggregation of Agg1 . The grouping is done by Group field and Agg 1 is shown at that level. Is there a way I can hide the entire grouping if Agg 1 does not meet a certain criteria? Likewise I would like to highlight specific rows in the expanded group based on values in one of the calc fields (varies depending on situation). In the example below, I would want to hide all of Group 1 (Group 1 row w/Agg1 as well as Name 1.1 and Name 1.2 rows) if Agg 1 is less than a designated threshold value. Is there a way to do this? Group 1 Agg 1 Name 1.1 Calc 1 Calc2 Calc 3 Name 1.2 Calc 1 Calc2 Calc 3 Group 2 Agg 1 Name 2.1 Calc 1 Calc2 Calc 3 Name 2.2 Calc 1 Calc2 Calc 3

I have not @kpcollier. Just powered through the task at hand and refreshed them one at a time.