ID and Label in field databasejoin

[germanoalves]

Hello!

I have a problem with a dbjoin field.

Instead of saving the label of the items, he is saving the ID.

How do I save the item label?

Thanks!

 

[startpoint]

The dbjoin element work properly in this way - save id in db instead label.

Try to learn how to Fabrik works.
Read Wiki, every element tooltips, every help on every element, ....
Then test, test, test ...

 

[germanoalves]

Great answer!

If I'm here on the forum to ask, it is precisely because I have already read the Fabrik wiki, and in my tests I have not been successful.

And I'm also trying to understand after researching, how things work

 

[lousyfool]

Well, it's the whole trick of the dbjoin to save the "key" = id of the joined table row instead of the label. This way it also works if the label is getting changed/renamed in the joined "source" table, and with multi-select elements.
You could try to pick another column as "key", but it isn't recommended, indeed.

Alternatively, you may also consider using dropdown/radio/checkbox elements, where you can enter what's stored as value in the main list table.

 

[germanoalves]

Perfect!! thank you!!