Bring image as signature from another table

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

0 16 299
  • UX
16 REPLIES 16

Rifad
Participant V

You can try using

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

Steve
Participant V

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

See also:

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

Then this earlier suggestion is a good one:

See also:

There is a correction in this:

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

This works.

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

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

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

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

This message appear

I find it difficult to understand the relationship between both tables

You should put the initial value formula

in signature column

3X_0_d_0d8ad29301e841e2f2620569e79eaa65480ca4e3.png


Signature as image type and signature
3X_a_7_a7a3b71487585345876c29022e611de21e06199e.png

employee table structure
3X_2_9_29b9ee177dc312909047b619f658fc290c70d374.png

What is the column type for official de cuadrilla?

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 ?

You’re GOD!!

It looks like what I’m looking for
3X_e_8_e85a65293598f2b35654165928cea4f0fa1de564.png

Thank you so very much Rifad!!!

Top Labels in this Space