For each repair form submitted there can be several images (photos) that can be taken of damage. These images will need to be emailed. When I attempt to attach the column โrelated imagesโ to a workflow, I receive the message โThe expression is valid but its result type โNumberโ is not one of the expected types: Drawing, Image, Thumbnail, Signature, File, Textโ
How are you attaching the column to the workflow?
On the workflow, I have an expression of [related images] on the โOther Attachmentsโ field.
Based on the error, Iโd have to assume the related images column is of type Number.
When it auto created it defaulted to โlistโ. Should I change it to โimageโ?
Try ANY([related images])
.
ANY([Related Images]) returned โThe expression is valid but its result type โRefโ is not one of the expected types: Drawing, Image, Thumbnail, Signature, File, Textโ
Does the Image table contain any columns of the required types?
Images table looks like this:
Note that your designated key column for the Images table is _RowNumber, but it appears you intended to use the Key column for this purpose. That explains why the error complained about a number.
For Other Attachments, try [Related Images][Image]
. Note that the is no period between the two column names.
Images are not attaching. It was working but am unsure when it broke and so donโt know what actually caused the issue. Update Iโve gone back to a previous version and things are working better now. Odd thing, now, is that the attachments(images) are not on the sent email unless I send it from a test and then all the images are attached.
Hi Judi,
Your Images table should have a Ref field that refers to the parent table record.
Is the โFKEYโ field the Ref column doing this?
If so, there will be a system added Reverse Ref field in the parent table.
It will contain the list of keys of the corresponding child records in the Images table.
In your workflow template, you can include a Start expression that uses the Reverse Ref field to retrieve and display each of the child Images records.
Is this what you mean? <<Start: [Related Images [Image]]>>
Iโve added it to my โother attachmentsโ expression, but see the following error:
Expression โ<<Start: [Related Images [Image]]>>โ could not be parsed due to exception: The given key was not present in the dictionaryโฆ
In โOther attachmentsโ try
[Related Images [Image]][Image]
Unable to find column 'RELATED IMAGES [IMAGE]][IMAGE]
It look like you are missing the opening [
[Related Images [Image]][Image]
I have this entered: [Related Images [Image]][Image]
The error reads: Unable to find column โRELATED IMAGES [IMAGE]][IMAGEโ
Can you provide
acct id: 335788
app name: Chromebook Repairs
workflow rule: Email Media
Hi Judi,
It looks like you fixed it.
The correct expression is: [Related Images].[Images]
I was confused about the name of your Reverse Ref field in table โFormsโ.
I did not realize that the Reverse Ref field name was simply โRelated Imagesโ.
I thought your Reverse Ref field was called โRelated Images [Image]โ because that is close to our old default naming scheme for Reverse Ref fields. Sorry for the confusion.
Is it working for you now? Are the image being attached to your emails?
It wasnโt working with that yesterday. Today, I canโt even get an email. However, I see everything it coming through okay on the spreadsheet. However, I am having other issues with Google blocking forwarded emails from less secure sources today,.
-------UPDATE------- I undeployed the app. I received an email, but with no image
Hi Judi,
The email did not contain the image because of the order in which the form was added and the image was added. The form record was added first and this immediately triggered the workflow rule. The image record was added a few seconds later, so it was not yet present when the workflow rule was triggered. That is why the image was omitted from the email.
Your expression is correct and it would have worked had the image been present.
How do I change the order they are added?
See topic " Sending Email After Adding a Parent Record and All of Its Children" in this article https://help.appsheet.com/behavior/workflow-introduction/workflow
Email isnโt being sent unless I choose โall changesโ on the form saved event on my action. then it will send the email, but no attachments,
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |