Related Images

Judi_Phelps · 05-15-2019 06:45 AM

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”

Steve

How are you attaching the column to the workflow?

Judi_Phelps

On the workflow, I have an expression of [related images] on the “Other Attachments” field.

Steve

Based on the error, I’d have to assume the related images column is of type Number.

Judi_Phelps

When it auto created it defaulted to “list”. Should I change it to “image”?

Steve

Try ANY([related images]).

Judi_Phelps

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”

Steve

Does the Image table contain any columns of the required types?

Judi_Phelps

Images table looks like this:

Steve

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.

Judi_Phelps

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.

Phil

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.

Judi_Phelps

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…

Phil

In “Other attachments” try
[Related Images [Image]][Image]

Judi_Phelps

Unable to find column 'RELATED IMAGES [IMAGE]][IMAGE]

Phil

It look like you are missing the opening [

[Related Images [Image]][Image]

Judi_Phelps

I have this entered: [Related Images [Image]][Image]

The error reads: Unable to find column ‘RELATED IMAGES [IMAGE]][IMAGE’

Phil

Can you provide

Your account id
The app name
The workflow rule name

Judi_Phelps

acct id: 335788
app name: Chromebook Repairs
workflow rule: Email Media

Phil

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?

Judi_Phelps

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,.

Judi_Phelps

-------UPDATE------- I undeployed the app. I received an email, but with no image

Phil

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.

Judi_Phelps

How do I change the order they are added?

Phil

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

Judi_Phelps

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,