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]))

[lynchk21]

Sorry I might not understand exactly your scenario - the Hungarian is a challenge to my thinking. However, you should be able to follow these steps:

First, how do you indicate what customers have opted the 'autofill' option?

1. Do you have their signature saved on the customer table?
2. Do you have a column on the customer table that indicates their option (i.e. "Autofill", "Undersign")

For either way, you need to put your expression in the initial value column. For example, either:

1. [Customer].[Signature]
2. IF([Customer].[Status]="Autofill",LOOKUP([Customer],"Orders","Customer","Signature"))

You can then set the editable_if column to either:

1. ISBLANK([customer].[signature])
2. [customer].[status]<>"Autofill"

[Hege7779]

Hi I've tried the version 1. Cause in my Order Table , i have "Signature" Column and "Customer Name" who received the package , letter. Also my Customer Table , have "Customer" and "Saved Signature" , in this case , which one have to writing to Initial Value ?

And what i need to write Editable IF column ?

Cause some reason doesnt wprk what you wrote down.

Thanks so much.

[lynchk21]

In the [signature] column on your Order table, for the initial value you can put [Customer Name].[Saved Signature] assuming that [Customer Name] is a reference to the Customer table. Then for the Editable_if, you can put ISBLANK([[Customer Name].[Saved Signature]])

Let me know if you have questions,

[Hege7779]

Thats clear, but unfortunately , i dont have Reference between , Order and Custom Name Table, just Order Table and Companies Table . In this case i have to make REF Column, which is pointing Customer Table , how can i call this column ?  I have Contact ID row in my Customer Table . 

Also i use Enum list for choose the Receiver Name where this is the expression: Megrendelők[Megrendelő Név]

This means : Megrendelők= Customer Table Megrendelő Név= Customer Name 

Thank you very much your help. Im really appreciate that . 

Kindly regards: Krisztian 

[lynchk21]

You can use a LOOKUP() function in that case:

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

but this assumes there are no duplicate customer names.

I would just set my [Customer Name] column on the orders table to a reference to the "Customers Table". 

[Hege7779]

Thanks so much Half Successfull , Cause if the Customer Has "Saved Signature" autofill the Signature Box, but if doesnt, dont comes up the Signature Box at all, i dont have a chance to ask my Customer to Undersign somewhere . How could i fix this ?

[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!

[Hege7779]

Thank you so much, i will try tonight or max tomorrow night, im really appreciate your massive help. And yes keep fingers crossed !!!

[Hege7779]

Hi, i've tried to writing in my Order Table what you wrote back, and i have an error message when i wrote this: ISNOTBLANK([_this]) Next to the Show_If

This is the error: Unable to find column '_this', did you mean 'Dátum'?

[Hege7779]

Finally what i wrote last time, thats worked somehow, but now this one doesnt work :

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

and this is the message : was unable to be parsed: Number of opened and closed parentheses does not match.

So almost there . Thanks so much again.

[lynchk21 · Accepted solution]

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

[Hege7779]

Thank you so much, now it works fine, only problem is, just a little one, the Signature Box behaving is strange , cause if you start to undersign , then you stop and would like to continue you couldnt do that , any idea , whats generating this ? (This didnt happend before ) 🙂 Anyway , thank so much your help, your time. Also need to making another Column in the PDF but thats what i expected . Have a nice day . 

[lynchk21]

Check the editable_if expression. If you still have one, you should be able to get rid of is=t since you are hiding the column.

If you don't have one, it might be something to do with the show_if since the field is no longer blank once you start signing. In that case you would have to write an expression to continually show the column for undersign

[Hege7779]

Hi. 

After the Signature this my Editable_if expression : AND(ISBLANK(LOOKUP([_thisRow].[Átvevő Neve],"Megrendelők","Megrendelő Név","Tárolt Aláírás")),ISBLANK([_this]))

And i dont have any expresson here just this. 

After Saved Signature (Virtual Column ) this is the expression:

if(ISNOTBLANK([Aláírás]),[Aláírás],LOOKUP([_thisROW].[Átvevő Neve],"Megrendelők","Megrendelő Név","Tárolt Aláírás"))

And this is Editable_if expression: 

ISNOTBLANK([_this])

What i need to write and where? 

[lynchk21]

Remove the editable_if expression : AND(ISBLANK(LOOKUP([_thisRow].[Átvevő Neve],"Megrendelők","Megrendelő Név","Tárolt Aláírás")),ISBLANK([_this]))

[Hege7779]

I've done and now the Signature is back to normal, but unfortunately doesnt work the autofill things , if if i choose someone whos get saved signature , not autofill anymore. I made a mistake somewhere . 

[lynchk21]

In the editable_If try ISBLANK(LOOKUP([_thisRow].[Átvevő Neve],"Megrendelők","Megrendelő Név","Tárolt Aláírás"))

[Hege7779]

Hi again, sorry for the message before, so now its still work but if I have saved signature, comes up the Saved signature and also I could undersign ín the box. I think I shoukd have modify the Show if expression?

[lynchk21 · Accepted solution]

For your [Signature] column for the show_IF you could use ISBLANK[Saved Signature]

I am a little confused on exactly what expressions you are using, so sorry if this is what you already have!

[Hege7779]

Hi Good Evening.

Thank you very much all of your help. This works almost well. Except one thing, comes back the Signature Boy problem, 🙂 When someone start to undersign , and stop just  a second, locking the signature box , and couldnt editing or continue to the undersign process , i dont know why ?

But i try to delete or modify the expression somehow.

Thanks again, im really appreciate your help.

Kindly regards: Krisztian

[Hege7779]

HI sorry again.

Finally i Solved the problem, used this expression here :

"Saved Signature" Show : ISBLANK[Signature] Seems to be works, now i need to edit the PDF Template .

Thanks again.

Kindly regards: Krisztian

[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