Combining Addon fields values to display in datagrid

Ask us anything How do I?
1

I am looking to display the combination of two fields from an Addon (Xano) in a datagrid column.

For example, I would like to display first_name +" " + last_name from the _person object within my collection. I have no issues displaying one or the other by using _person.first_name or _person.last_name in the Key value for the column.

2

Hi,

you can choose a custom type inside datagrid column option and then place any element inside (div, text, etc). By that you can create any UI you want.

image
image293Ă—699 20.8 KB

image
image397Ă—113 3.54 KB

1 Like
3

You can use the custom display value, see on the screenshot

image
image937Ă—680 47.1 KB

1 Like
4

Thanks for the reply. This did the trick! While your response did help, it took a couple looks to see what the answer was. I will elaborate here to help others.

To reference the fields in the object within the collection, you need to refer to the object name in the “Key” text box. Once you do that you can access the fields within the object in the Display value formula. These will appear under the mapping.Item per antoine_caron’s post.

So in my case I set the Key for the column to the object name of “_person” and then the formula for Display value is set to
Mapping.first_name +" " + Mapping.last_name.

1 Like
5

So how would this be done when the 2 fields you want to concat are a part of the object that makes up the row itself? I tried setting the key to “item” and “items”, but I don’t get the expected mapping options.

6

I don’t think you can do it this way, but what you can do, is set the type to custom.

image
image369Ă—269 10.1 KB

Put a text in the custom cell, and when you’ll bind the text it will show you the whole row object, then select anything you want from there :

image
image229Ă—116 2.61 KB

2 Likes