I would like to have a form to select a bunch of e-mail addresses from a table to be set as BCC.
The form when saved should take me to the default e-mail editor (like it happens when we click the ‘mail’ icon next to an email address) with the BCC fields pre filled as selected in the form, rather than having an workflow send the email in the background.
This is a very specific requirement but it’s there.
Is there a way to achieve this?
Solved! Go to Solution.
Option #1 - Only a single file attachment
1.) Add a physical column to your table at the end (or where-ever you see fit😞 [Attachment] (Type: File)
2.) In the workflow rule set-up, refer to this column in Other attachments section:
Option #2 - Multiple file attachments
1.) Create an Attachments table with 2 columns: ID (Type: Text) and File (Type: File)
2.) Create a ref in ID column to your workflow table with isPartOf set to TRUE/ON
3.) You can hide this column from normal operation if you want to select attachments only when triggering the workflow
4.) Create a slice of your workflow table containing only the Key Column and Related Attachments virtual column
5.) Create a ref type Form view and assign the slice in Step 4 to this form
6.) Create an Action in your workflow table:
LINKTOROW([Key_Column],"your_ref_form_name_from_Step5")
7.) Refer to [Related Attachments] column in Other attachments section in your workflow
HTML Reference
You can easily do that with an Action. You can choose to display it prominently in the Detail view or attach it to a column in table view displayed inline.
Is there a way to input the BCC recipients?
You can set an expression in the BCC property for that
Please, would you point me to where is it?
My specific requirements are to attach images, some pdf attachments and some text formatting. Is it possible without the action and only through the workflow?
Attachments and text formatting (thru HTML) is only possible with Email Workflow.
When the e-mail action is selected then the action takes us to an email editor rather than sending the email already, right?
There is an option to attach documents and format texts from within the editor, right?
Re: Is there an option through the workflow approach, to attach images and documents (not documents which are produced through the workflow and attached to the email, but just a random document) ?
I haven’t understood this part. And as you are opening the native email client, you don’t need to specify any attachment, CC and/or BCC as you can easily specify them directly in the client.
There are documents and images in the computer. I want to attach them to the email. If I make a form and keep two file upload columns, and input image in one and pdf in the other, and specify those columns in the email workflow, can it be done?
The only problem in specifying the BCCs is that there are a lot, and ‘Selected’ from a table. If I have to input those BCCs directly in the editor, it’s a humongous job, and is likely to piss people off.
There are documents and images in the computer. I want to attach them to the email. If I make a form and keep two file upload columns, and input image in one and pdf in the other, and specify those columns in the attachment, can it be done?
Yes of course
The only problem in specifying the BCCs is that there are a lot, and ‘Selected’ from a table. If I have to input those BCCs directly in the editor, it’s a humongous job, and is likely to piss people off.
I still propose and advise using Email workflow and don’t mess with the external email client
[/quote]
I still propose and advise using Email workflow and don’t mess with the external email client
[/quote]
Sorry for being too nagging and indecisive, but will the above process allow me to do all of these:
Attach image and pdf from the computer or device?
Format the body text according to will? Can I give a column specifying the format rules?
- Attach image and pdf from the computer or device?
There are 2 options for this regarding the number of files that you would like to add
- Format the body text according to will? Can I give a column specifying the format rules?
You can indeed format the email body as you like with using classic HTML tags. But you can’t refer to a Format Rule setting unfortunately.
What are the two options?
For th second part, unfortunate on the thing I’m working on
What are the two options?
Option #1 - Only a single file attachment
1.) Add a physical column to your table at the end (or where-ever you see fit😞 [Attachment] (Type: File)
2.) In the workflow rule set-up, refer to this column in Other attachments section:
Option #2 - Multiple file attachments
1.) Create an Attachments table with 2 columns: ID (Type: Text) and File (Type: File)
2.) Create a ref in ID column to your workflow table with isPartOf set to TRUE/ON
3.) You can hide this column from normal operation if you want to select attachments only when triggering the workflow
4.) Create a slice of your workflow table containing only the Key Column and Related Attachments virtual column
5.) Create a ref type Form view and assign the slice in Step 4 to this form
6.) Create an Action in your workflow table:
LINKTOROW([Key_Column],"your_ref_form_name_from_Step5")
7.) Refer to [Related Attachments] column in Other attachments section in your workflow
HTML Reference
Thanks.
One more thing, when an email is sent from a workflow, and a reply to that email is attempted, the reply email address becomes noreply@appsheet.com. Is there a way to change this?
One more thing, when an email is sent from a workflow, and a reply to that email is attempted, the reply email address becomes noreply@appsheet.com. Is there a way to change this?
There is a REPLY TO setting in the email workflow.
Sorry for asking. Fixed it. Its in the reply to field
You’re welcome. Glad to hear that you have figured it out. Excellent work.
2.) Create a ref in ID column to your workflow table with isPartOf set to TRUE/ON
I should add a column in the workflow table with name, say, Files and set that column as a reference to the attachment table with ispartof on?
If I do that, the file column in the workflow table gets set as a ref to the Attachments table, rather than showing a ‘NEW’ option as generally happens in case of isapartof.
I’m sorry again for being a dork. It should have been the other way around.
If I do that, the file column in the workflow table gets set as a ref to the Attachments table, rather than showing a ‘NEW’ option as generally happens in case of isapartof.
Of course you will not put the ref column. You will put [Related Attachements] (or whatsoever the name it will be) Virtual Column created by the ref
4.) Create a slice of your workflow table containing only the Key Column and Related Attachments virtual column
5.) Create a ref type Form view and assign the slice in Step 4 to this form
6.) Create an Action in your workflow table:LINKTOROW([Key_Column],"your_ref_form_name_from_Step5")
Just one more thing, please.
Is this block of code (or whatever you call it) necessary for the files to get attached and sent with the email? Or is this just for viewing?
Is this block of code (or whatever you call it) necessary for the files to get attached and sent with the email? Or is this just for viewing?
it’s the only way to put multiple files all at once as an additional attachment to your email workflow which will also trigger it upon form save.
I have worked like this:
Created an attachment table with cols ID (key) and File.
Have set that ID column as reference to the workflow table.
Is this the right approach? Tell me this first
I have worked like this:
- Created an attachment table with cols ID (key) and File.
- Have set that ID column as reference to the workflow table.
Is this the right approach? Tell me this first
Correct
I know I have nothing to stress about when there is an excellent support team like appsheet’s and gems of people like you. I’m thankful to be able to be a part of Appsheet and this community.
Then this ‘broken reference’ gets created. Is this normal to happen?
And no new files get saved in the form. And when I try to save, the message shows 'there already exists a row with key … "
Adding another column and making it the key column and making the ID column the reference to the workflow table eradicated the broken references. But is this at all the true approach?
Then this ‘broken reference’ gets created. Is this normal to happen?
And no new files get saved in the form. And when I try to save, the message shows 'there already exists a row with key … "
That’s possibly because of my mis-explanation, sorry for that. I haven’t explicitly told to keep the Key column of that Attachments table separate from the ID and FILE columns. As the ID ref column will always take the key column value of the parent table, it will contain duplicate values and therefore cannot be assigned as a key column. But I noticed that you have already solved the issue.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |