Signature

[Hege7779]

Hi Everyone.

I have a question, I Have Order Table with Signature Box, In this Table you can choose Receivers Name from Customer Table . My few Customers has Saved Signatures , but also a few dont want to store they signature , they always want to undersign everytime, meanwhile someone want to Autofill they Signature from the Saved Signatures when you choose they name on the Drop down Receivers Customer List. I tried few Lookup Expression, get back Saved Signature , but some reason couldnt add manually , this is the expression :

IF(ISNOTBLANK([Átvevő Neve]),
IF(
LOOKUP([Átvevő Neve],"Megrendelők","Megrendelő Név","Aláírás")<>"",LOOKUP([Átvevő Neve],"Megrendelők","Megrendelő Név","Aláírás"),IF(LOOKUP([Átvevő Neve],"Megrendelők","Megrendelő Név","Aláírás")="","Undersign","")),"Manual Input"

The Language is Hungarian "Átvevő Neve"=Receivers Name, "Megrendelők"=Customers , "Megrendelő Név "=Customers Name, "Aláírás"=Signature , so if you pick Receivers Name actually you see Customer Name list .

How could i modify this Expression, to able to add manually signature if is not saved ?

[Hege7779 · Accepted solution]

Hi thank you very much your help im really appreciate that, sorry for a belated answer, we organising a Courier Company small, today afternoon if I have I will check your suggestions. Then im writing, im sure I will have question about IT. Thanks again,have a nice day 

[lynchk21 · Accepted solution]

Even with this formula is the initial value it doesn't show when the customers [Saved Signature] in blank? It should not work like that, but it that is the case you will probably just have to use a workaround, such as:

1. Create a virtual column [Customer Signature] with an expression like if(ISNOTBLANK([Signature]),[Signature],LOOKUP([_thisRow].[Customer Name],"Customer Table","Customer","Signature"))
2. For [Customer Signature] add a show_if ISNOTBLANK([_this])
3. Remove the former expression from your [signature] column
4. In the [signature] column add a show_if expression AND(ISBLANK(LOOKUP([_thisRow].[Customer Name],"Customer Table","Customer","Signature")),ISBLANK([_this])
5. Add both columns to your form view
6. In theory, the [signature] column will only show if the [saved signature] column is empty, at that point the customer can sign, which will then hide the [signature] column and display the virtual [customer signature] column with the signature.

Not sure if this will work, it is the best I can think of without seeing your data. Fingers crossed!

[lynchk21 · Accepted solution]

AND(ISBLANK(LOOKUP([_thisRow].[Customer Name],"Customer Table","Customer","Signature")),ISBLANK([_this]))