Hello
I have a database (DB_Email_Campagne) with the following fields:
- body (text)
- email header (image)
- subject line (text)
- campaign name (text)
- campaign status (Option set: draft, sent)
- company user (link to related table company user)
1) I have a Reusable element (RE-emailing) that:
- contains a header section (title + button → add a campaign)
- a switch button section (campaign, recipient, and send) that allows me to display either content in this section.
For the campaign content, I have a repeating group in the form of a list, the same for recipient and send.
2) I have a Reusable element (RE-campaign-details) which:
- contains a header section (title + button → save a campaign)
- a content section that contains an input field (campaign name), and a switch button section (template, and custom) that allows me to display either content in this section.
In the custom content: I have an input field (subject line), a multiline input (body text), a picture uploader (email header image), and a signature group.
What I want:
When I click on the button (add a campaign) in my RE-emailing header, I would like it to create an entry in the DB_Email_Campagne database, with the campaign status → draft, email header → current user company header image, company user (current user company user), and for this data to be sent to the RE-campaign-details and displayed on the RE-campaign-details page.
In RE-campaign-details:
I would first like the email header image field to be pre-filled.
Then, when I modify the campaign name input, subject line input, multiline input body text, and image uploader header image, and I click on the button; save a campaign in the RE campaign details header, I want the information to be visually modified in the content and also in the DB_Email_Campagne database.
When I return to RE-emailing:
Display in my repeating group list: the campaign name, campaign subject, campaign status, and creation date.
When I click on one of the rows in this repeating group, it should display in RE_campaign-details the content corresponding to that row.
Important: the data transfer happens between the two distinct reusable elements; these are not pages but reusable elements. I think Data transfer must be done via parameters or custom states.
Thank you for your help