Signature on Workflow report

[Romain]

Hi community,
I have an inspection workflow rule which generate a report when an inspection is finished.
The workflow condition is AND([Status]=“Closed”, [Signature]<>"")
This works correctly but the report is generated with a blank instead of the image of the Signature.

If I force a 2nd time, the image of the signature is on the report…

Is there any problem of delay because it is an Image
Here below the 2 results

When the normal Workflow send the report

When I force a 2nd time

[Aleksi]

Is it possible that these signatures are coming from a child record and you trigger the Workflow from parent record?

[Romain]

Hi @Aleksi
Actually not.
It works like this :
I have a table Convocation and another one called remarks
All remarks are child records of convocations.
When a convocation is finished, I have a action button which set [Status] =Close and open a form to add a signature on the Convocation row.
When form is saved the workflow is executed because all conditions are true (AND([Status]=“Closed”, [Signature]<>""))

In the report I have data from Convocation (Date/Location/Name/Signature) and from the table remarks with a start expression to display all remarks concerned by the Convocation.

Everything works well exepted the signature which not appears. The Signature appears on the report if I click a second time on the action button
All data are on GoogleDrive

When I synchronize the app and have a look on GoogleSheet, I see there is a little delay on column Signature (Status appear Closed then after Signature is filled). Is this cause this problem on report? I don’t think because the workflow is executed even if I don’t click on he Sync Button.

[Aleksi · Accepted solution]

It sounds that your workflow is triggered when you update the record with the Status change. At that point you don’t have the signature yet. Try to add a condition rule like…
AND(
ISNOTBLANK([Signature]),
[_THISROW_BEFORE].[Signature]<>[_THISROW_AFTER].[Signature]
)

[Romain]

Aleksi:

AND(
ISNOTBLANK([Signature]),
[_THISROW_BEFORE].[Signature]<>[_THISROW_AFTER].[Signature]
)

@Aleksi
It Works perectly, Thanks!
I still not understand why the report is triggered with the previous condition when status changed without Signature but your solution is working.
Thanks !!

[MJvanEwijk]

Hi, can you help. Sometimes I see only the signature link and not the picture, see screen shot…!
Hope you can help…

[Steve]

There are ongoing problems with image inclusion in PDFs. Please contact support@appsheet.com for help with this.

[Aleksi]

If the Signature field is blank, this part [Signature]<>"" is actually TRUE. This is a special case where the evaluation is like blank <> blank which is always TRUE.

[Romain]

@Aleksi
ok, now I understood the diffecence between <>"" and ISNOTBLANK().
Improving every day
Thanks for feed back!

[Orion_Szathmary]

Aleksi:

[Signature]<>"" is actually TRUE

This topic is helpful. Could you clarify why [Signature]<>"" is actually TRUE. I see you say it’s a special case “where the evaluation is like blank <> blank”. I’m not sure I understand the difference Is it simply that “” is looking for an empty string which is <> (not equal) to an empty image / signature file?

[Steve]

The = and <> operators have a quirk: if the left-side operand is a blank value, the value of right-side operand is ignored entirely and the expression evaluates as TRUE.

[Orion_Szathmary]

Thank you. I love this community. The quality of the support on here - and the speed with which it is delivered - is unrivalled. Thank you!

[Aleksi]

You’re welcome