Lauren

Thanks Volomeister! I'm not sure I understand the workaround, but I really appreciate the troubleshooting. For example, in my event registration table, I would like to use the AI plugin to create 3 different times from our UTC event time field, one in PST, CST, and EST. This is used for MailChimp merge tags for event reminders. While this is great for new records and every new registrant moving forward, but it would be really cool if it could update old records for which people have already registered but the event hasn't occurred yet. This is just an example, I'm just thinking of all the use cases I might be able to apply for now.

I'm really excited about this integration and have been playing around with it recently. I am looking forward to all the ways it can improve and transform new data coming in, but I wonder if there will be a point where we can also use it on data that exists already rather than an insert or update trigger. I understand how this could be an issue if people aren't careful, but for example when I create a new field to format a date in a way that I want it, it only works with new or updated records if I'm understanding correctly. It would be nice if I could also have that prompt affect older records instead of leaving them blank, if that makes sense.

This is an old post, but I have what I think is a similar question, except I'm using Tasks not Triggered Actions. I am using a task to update data from a child table to a parent table, but I also do not have the primary key ID in the parent table until a new child table record is inserted, because it's a participant registration table. My parent table is a participant tracking table, that issues participant IDs for unique participants (no duplicates, updates data based on new records in the child table that have updated data using tasks). I have some data pages running on the Participant_tracking_tbl, and I need a formula field that exists in my child table to be copied over. I am using tasks, and this works for all the other fields I have copied over/updated, except for formula data types. I am assuming it is a similar issue because these need to use #inserted or the parameter [@field:InsertRecordVariable], but I can't figure out how to do this in tasks since I am updating records that already exist and were not just inserted. Any ideas? Thanks!

@CoopperBackpack This is amazing and is exactly what I was looking for! Thank you so much for your clear, detailed instructions. This is perfect and will be used across multiple reports.

Hi everyone, I searched the forum already and I can't seem to find what I need to help me with my use case. I have a table Participant_Registration_tbl1 that has 10 fields pertaining to what system a participant works in (for example, System_1, System_2, System_3...System_10). I opted to separate our options for specific questions as unique fields instead of using multi select listboxes, essentially. I want to create a tabular report that displays a column showing all the systems that the person selected. Data type is text and uses the text of the field (so for example, System_1 might be [@field:healthcare] and the data when selected would be 'Health Care'. I want to use a virtual field to concatenate these fields to display into one column, ideally in a bulleted list (although I know that's asking a lot). Next best case would be to concatenate them together using commas, but I don't want it to show a bunch of commas and spaces if the person only selected one out of 10 options. Is there any way to do this? To summarize, if the person selected both 'Health Care' and 'Social Work' but no other options of the 10 fields, I want it displayed as: Health Care Social Work OR: Health Care, Social Work but NOT: Health Care, , , Social Work, , , , , , Thanks in advance!

Hi! This is old, but hopefully you see it. I found your post, as I am trying to accomplish an 'add to calendar' button, and using your script the button is not clickable. Nothing happens - can you point me in the right direction to troubleshoot this perhaps? Thanks!