I'm using CiviCRM 5.41.2, CiviRules: Version 2.41, Drupal 7.87
I am trying to create a webform where the user submits a number of documents. They also select their region from a drop down list, triggering a conditional that displays a listbox of organisations tagged with that region and they would select one of these from the list. What I would like to do is send the submitted documents to the selected organisation and a copy of the webform.
I could do this through a conditional I think but if any organisation changed their email address, it would need changing in the conditional. I would prefer if the process was accessing the current email from the organisation's database entry.
I do not want to display the email address of the selected organisation to the user which would enable this to work I think. If there is a hidden email field for the organisation, when the user submits the webform, they wipe the organisation's stored email address - I guess because the field is considered empty unless it is displayed? I have had a look at CiviRules but can't figure out a way of either attaching a document to the template or copying a submitted webform as part of the action. I think what I'm trying to do may be possible using Hooks but setting that up may be beyond my skills.
Is using a Hook the only way to do this or am I missing something? Thanks for your help!