Bring image as signature from another table

[Leonardo_BONORI]

Hello, I need your help!
I have two tables, “employee” and “inspection”, In the employee table there are three columns employee id, name, signature (image jpg).
How can I make the “Inspection” form automatically bring the signature (image jpg) associated with it when choosing an employee

Thank you

[Rifad]

You can try using

LOOKUP(Employee ID,Employee,Employee ID,Signature)

[Steve]

In the employee table, mark both the name and signature columns as label.

See also:

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

[Leonardo_BONORI]

Thank you very much for your reply.
In this form I choose two employees with ENUM
To the Crew Officer with SELECT (EMPLOYEE [EMPLOYEE], TRUE) and to the crew assistant with SELECT (EMPLOYEE [EMPLOYEE],
[STAFF OFFICER] <> [_THISROW]. [STAFF ASSISTANT], TRUE)

I don’t know how to show the signatures

[Steve]

Then this earlier suggestion is a good one:

Rifadm817:

You can try using

LOOKUP(Employee ID,Employee,Employee ID,Signature)

See also:

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Rifad]

There is a correction in this:

LOOKUP([_thisrow].[Employee ID],Employee,Employee ID,Signature)

This works.

[Leonardo_BONORI]

Thank you very much Rifad!
I can’t get it to work!
I need to bring the signature of the selected employee in the “crew officer” field in the “crew official signature” field

[Rifad]

You can set the column as signature and add intial value as above mentioned expression.

[Leonardo_BONORI]

Rifad, when I enter the formula it gives me this error

[Rifad]

You should change the Column type ENUM and set as REF column base type and select table EMPLEADO Table.

Then change the formula to-

LOOKUP([_THISROW].[OFFICIAL DE CUADRILLA],EMPLEADO,ID EMPLEADO,FIRMA ELECTRONICA])

[Leonardo_BONORI]

This message appear

I find it difficult to understand the relationship between both tables

Rifadm817:

LOOKUP([_THISROW].[OFICIAL DE CUADRILLA],EMPLEADO,ID EMPLEADO,FIRMA ELECTRONICA])

[Rifad]

Leonardo_BONORIS:

I find it difficult to understand the relationship between both tables

You should put the initial value formula

Rifadm817:

LOOKUP([_THISROW].[OFICIAL DE CUADRILLA],EMPLEADO,ID EMPLEADO,FIRMA ELECTRONICA])

in signature column

[Leonardo_BONORI]

Signature as image type and signature

employee table structure

[Rifad]

What is the column type for official de cuadrilla?

[Rifad]

Rifadm817:

You should change the Column type ENUM and set as REF column base type and select table EMPLEADO Table.

For Column OFFICIAL DE CUADRILLA
Column Type: ENUM
Base type: Ref
Source Table: Empleado

Suggested values or Valid if put this expression- EMPLEADO[ID EMPLEADO]

[Rifad]

Rifadm817:

For Column OFFICIAL DE CUADRILLA
Column Type: ENUM
Base type: Ref
Source Table: Empleado

Suggested values or Valid if put this expression- EMPLEADO[ID EMPLEADO]

Did you do like this for OFFICIAL DE CUADRILLA ?

[Leonardo_BONORI]

You’re GOD!!

It looks like what I’m looking for

Thank you so very much Rifad!!!

Rifadm817:

EMPLEADO[ID EMPLEADO]