My system allows people to sign up for projects and when they sign up, I have an automation running that adds them to the projects table from the users table. The issue is, it’s not allowing that user to be added to multiple projects. If a user clicks the link on a different project, they are removed from the first one. Any insights on why this behavior is happening?
This is most likely because you are not adding back in the original data from the field. If only the new project is in the entry field of the Update record step it is basically replacing anything in there with the single new entry. Update the step with a comma at the end of the dynamic entry already there and then add another entry that is the field from when the automation was triggered, which still “contains” the old data. Then when the automation runs the new project is added to the previous list instead of replacing them.
This is most likely because you are not adding back in the original data from the field. If only the new project is in the entry field of the Update record step it is basically replacing anything in there with the single new entry. Update the step with a comma at the end of the dynamic entry already there and then add another entry that is the field from when the automation was triggered, which still “contains” the old data. Then when the automation runs the new project is added to the previous list instead of replacing them.
Thank you. I did figure that part out and fixed it. However, it's still removing the data from other projects. For instance, if a user signs up for Project A, their information is in the field. If they sign up for Project B, their information is being removed from Project A and being put in Project B. The field is set for multiple records. They should be able to sign up for multiple projects.
Hmm, that should work fine! I’ve created it here for you to compare against your own set up, and here’s a gif of it running:


I wasn’t sure how your base was set up though, so let me know if you’re still facing issues after this and I’ll see what I can do!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.