Jump to content
  • 0

Triggered Action Help




I have a triggered action that works, however it is so slow and clunky, and sometimes it times out. I am wondering if anyone can suggest a fix to make it faster or more efficient. It takes 15-20 minutes just to open this thing to edit it...

Attached is a screenshot of one block of the triggered action. This block is repeated about 400 times (one for each field. If you notice, the first field is: X2A1, and the second is X2A2 at the start of the second block on the bottom of the picture. Again, this is repeated for 400 fields.

The way it works is detailed below...

My GL Import table is a table which I will call tall (top to bottom). Here is a quick sample of the data for GL Import

ClientID   ProviderID   PeriodID    Field       Value

1                   1                         1                      X2A1       500

1                  1                          1                     X2A1        1000

1                 1                           1                    X2A2          1200


The balance sheet is wide (left to right) with each field displaying as one field left to right (the GL import table has all of the fields as labels in the row. Below is a sample layout of the Balance Sheet Table

ClientID    ProviderID      PeriodID       X2A1       X2A2     X2A3

1                    1                           1


Running this triggered action updates the balance sheet so it would look like this:

ClientID    ProviderID      PeriodID       X2A1       X2A2     X2A3

1                    1                           1                           1500       1200       0


The triggered action sums the values for each label in the field in the GL Import table, and takes that summed amount, and moves it to the correct field in the Balance Sheet table. Does anyone have any ideas on how to make this more efficient? 

Triggered Action Help.JPG

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...