Signature

AppSheet AppSheet Q&A
1

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 ?

2

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”
3

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

4

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.

5

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,

6

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

7

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

1 Like
8

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 ?

9

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!

10

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

11

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’?

12

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.

13

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

14

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 ) :slightly_smiling_face: 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 .

15

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

16

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?

17

Remove the editable_if expression : AND(ISBLANK(LOOKUP([_thisRow].[ÁtvevƑ Neve],“MegrendelƑk”,“MegrendelƑ NĂ©v”,“TĂĄrolt AlĂĄĂ­rĂĄs”)),ISBLANK([_this]))

18

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 .

19

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?

20

In the editable_If try ISBLANK(LOOKUP([_thisRow].[ÁtvevƑ Neve],“MegrendelƑk”,“MegrendelƑ NĂ©v”,“TĂĄrolt AlĂĄĂ­rĂĄs”))