Keep text formating with concatenate

1

Hi all!

I have 4 tables that correspond to types of materials (Used dyestuff, Used fibers, …, …) with a column that concatenates information from other columns (a code, the material [Name], quantity, measurement and cost).

concLB1
concLB11118×524 69 KB

In a 5th table (My experiments & products) I need to pull that information from the 4 previous tables and concatenate it in one column.

concLB2
concLB21396×1140 160 KB

I also reference this last column in the Canvas, in a formula for a Select control:

concLB3
concLB31628×946 130 KB

Why do I lose the bold text in the 5th table and in the Canvas formula?

Thanks!!

2

Hello @Filipa_Didier

Welcome to CODA community !

You may consider using Format() function instead of Concatenate(). I cant take your full example now, but see in this very quick example that format is kept with Format() function :

image
image679×533 40.1 KB

3 Likes
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.