Hi Folks,
How can I make the "Group By" option in the table tool update automatically ? I want the table to regroup itself based on dynamic input. What’s the easiest way to do this? Any examples or recommended approaches would be appreciated.
@code_diva What are you trying to achieve, I'm asking it as there might be another way to do it without using Table Tool. The reason that I'm asking is due to the reason that the minute that you will have fields each time in the Table you will need to ensure that the formatting that you are using is will assigned to the new seletion.It is possible what you are asking for, however there might be a different way to get the end result that you are seeking for.
@code_diva PFA
@Raj This is a really great solution. Thanks for sharing. -Jay
Thanks for the response. I'm working on sending email with multiple attachments using the email tool. The number of attachments changes each time I run the process, so it's dynamic. I'm trying to use a combination of Table, Layout, and Email tools to achieve this. How can I update the attachment fields in the Email tool dynamically to include all the files each time?
Thanks for the solution. Using this i am able to update Group By option in Table tool dynamically. Would you be able to help update attachment field dynamically in email tool.
@code_diva to dynamically grab files to attach, you can simply pull the write filepath + filename for each of the written files. It's already dynamic by nature, though, there is a catch (below).
Then, once you have those, Crosstab that field out so that it's in multiple columns. You can use the Email Tool's attach feature to select multiple fields to attach files to....
The catch: The downside to this is you really need to have a stable number of files that you're attaching since you have to specify them each, by field. The files can be different each time, but this approach works best when you always have X-number of attachments each and every time. You could play around with seeing what happens when one of those fields is empty though.
Hope this gives you some inspiration. -Jay
