Concatenate Part Number + descripcion de producto

[marinocity]

Hola!

Tengo una tabla madre VENTAS con una tabla hija DETALLE DE VENTAS, donde se ingresan los productos.

La columna PART NUMBER de la tabla DETALLE DE VENTAS hace ref al PART NUMBER de la tabla INVENTARIO.

Hasta ahi todo perfecto, cuando quiero ingresar un producto, se despliega la lista de los PART NUMBERS, se elige y listo.

Lo que me gustaria es poder ver la lista de PART NUMBERS concatenada con la descripcion del PRODUCTO.

Por ejemplo: Busco Part Number A1001 y que al lado muestre la descripcion A01 WEBCAM 1080p.
Eso me permitiria tambien buscar por producto, no solo Part Number

La formula que se me ocurre es CONCATENATE([PART NUMBER], " ", [PRODUCTO])
intenté agregarlo en initial Value y app formula pero da error

Es posible hacer esto?

gracias!

[Suvrutt_Gurjar]

Please try the following.

Please make the concatenated virtual or real column with the formula CONCATENATE([PART NUMBER], " ", [PRODUCTO]) as label of the table INVENTORY. Then you should be able to see both the description and part number in the drop down selection. This assumes that you have referenced the INVENTORY table in the SALES DETAILS table.

Add row labels - AppSheet Help

Please note the following sentence in the hep article 

"The Ref popup, which is shown when choosing a Ref row from the form also uses the labels."

[marinocity]

Thanks @Suvrutt_Gurjar 

I wanted bold part number and description product normal text, like that

Only is possible with 2 labels, but Appsheet dont save these changes.

Virtual colum and formula CONCATENATE([PART NUMBER], " ", [PRODUCTO]) as label, works but shows like that

any way to show me part number bold and description text normal?

Thanks!

[Suvrutt_Gurjar]

I am afraid you will not be able to partially format a part of the text string with format rules. However you could use some workarounds, if you wish. AppSheet allows one image and one text column to be simultaneously designated as labels.  

The following image example shows , I used TEXT_ICON() to create image of the product code column. However with TEXT_ICON() you cannot control the size of the font, so long part numbers of the product may not be visible by this method. 

TEXT_ICON() - AppSheet Help

You could however use some text overlay over images services as mentioned in the Tips and Tricks section. Please use them only after evaluating your security requirements and paid subscription if any of those services.

Add text as layer to Image - Free API service - Google Cloud Community

There are more posts on text overlay over image in Tips and Tricks section.

[marinocity]

Interesting option, thanks! @Suvrutt_Gurjar