Is it currently possible to allow users to submit custom data multiple times and store each submission separately? I've tried a few things with no success. Searching suggests this has come up before but there's no complete solution. Just want to confirm I'm not missing something before I give up.
Note that this application is in Joomla. I inherited this and cannot change at this time. Current Civi version is 5.64.4 which I know needs to be upgraded.
Goals:
- Anonymous user submits a form which contains both user info (name, email etc.) and custom fields.
- User can submit the form more than once. Typically this happens once every few months.
- Custom field info retained for each submission separately - ideally with date of submission.
- User info updated to the most recent using de-dupe rules.
- User and Admin user get confirmation email after each submission.
- Administrative user can export submissions from all users.
First attempt: Tab with table - New set of custom fields. "Tab with table" style. New profile for this set of fields and some contact info, and then "Use Create" mode.
Seems like it will work. Form is available, submitted data looks right on the tab. Unfortunately, the confirmation email always sends the info from the first submittal, not the most recent one. Export works kind of, but no date of submission. Upon further reading Tab with table isn't really a separate record for each submission which I think is creating the confirmation email issue.
Second attempt: Activities - New activity type, New set of custom fields for an activity of that type, new profile with those fields and user fields Unfortunately, form with mixed fields can't be used in create mode. (I also tried creating a form with FormBuilder, but that seems to have the same challenge.)
Third attempt: Cases - Basically same as Activities. There doesn't seem to be a way to expose a form to anonymous users. Even with just one field (not even a custom field, just case subject) I get "Profile search, view and edit are not supported for Profiles which include fields for more than one record type." which I think is a misleading error but regardless it doesn't work. Unless maybe it's a permissions problem? I've tried changing permissions but no luck.
Fourth attempt: Pretend this is an event - New participant type, New set of custom fields for participant of that type. New event, allow multiple registrants to the event from the same email. I believe this will work, but it would require me to modify the confirmation emails and front end screens to hide that I'm hijacking the event functionality. Seems like a lot of work, which has me wondering if there's a better way.
