I thought I was on my way to a solution until I stumbled upon some AS limitations (like primary action buttons in a table view, etc)- so let me spell out my desire to see if there any suggested solutions:
My data will consist of 2 tables which ideally will always match in number of rows (with the key value of the rows being the same). Table 1 is generated externally to AS/GS and will either be manually imported into GS from time to time or someday, Odata linking> MySQL or something similar may be built (let's stick with manual for this exercise).
The goal is for an admin person to be able to manually (because trying to do so automagically is unnecessary overhead for the expected/anticipated amount of time the data may possibly change) "sync" to ensure that when new rows are added in Table 1 (again, not from within AS or even GS), corresponding rows are created in Table 2.
My plan was to use Data: execute an action on a set of rows to evaluate (row by row) to see if the Table 1 row exists in Table 2 and if not, create it. I believe this is similar to what @Gustavo_Eduardo is asking in this post, but I figured I should ask here just the same to ensure I am not missing an easier way to accomplish my objective.
Solved! Go to Solution.
Ok, I got an automation to work (needing multiple actions, etc), but I needed to create a dummy table which shows me a comparison count between the raw data (table 1) and the merged data (table 2).
This all feels unnecessary if a Table could simply support a table wide (non-row level) action.
User | Count |
---|---|
15 | |
14 | |
8 | |
7 | |
4 |