Skip to main content
Solved

Display 2 results from 2 different columns on the database on the same card


Forum|alt.badge.img+4
  • New Member
  • 66 replies

Please assist - How to display 2 results from 2 different columns from the database on a card

Best answer by marcosmelo

Hi, @TMZ 

See a screenshot I posted in your other question. You can create two text fields with the names: Name and Email, for example. then, you create the automation using a trigger, let's assume it is the trigger when a card is created. Then in the action you choose, update fields, and then you have to choose the fields created Name and email and fill them in with the database information. You select the database that was filled in the initial form, and choose the Name and Email fields to feed the fields you created previously.
I don't know if I managed to explain it correctly.
But if you have any questions, send them here

 

 

 

View original
Did this topic help you find an answer to your question?

8 replies

marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • April 16, 2024

Hi, @TMZ 

Could you give more details than you need?


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • April 16, 2024

The database has user details Name|Email|CellNumber - 3 columns.  How would you display Name & email together with one selection & one card. Currently I have to search for Name in one field & then search for matching email in the next field.  Hoping to search for name & it automatically populates 7 displays matching email


Ezequiel Souza
Forum|alt.badge.img+14

Hi

As a suggestion is create new column with the values concatenated of the others 2 columns Name|Email| and use this as a identifier.

Pipefy doesn’t permit concatenate 2 columns into the same field.

Good Luck

 


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • April 16, 2024
TMZ wrote:

The database has user details Name|Email|CellNumber - 3 columns.  How would you display Name & email together with one selection & one card. Currently I have to search for Name in one field & then search for matching email in the next field.  Hoping to search for name & it automatically populates 7 displays matching email

Hi, @TMZ 

See this article helps you
 

 


lucas-lacerda-pipefy
Pipefy Staff
Forum|alt.badge.img

Oi @TMZ, tudo bem? 

 

No momento ainda não temos uma forma nativa de realizar essa função, mas é uma ótima ideia! Vou enviar para o nosso time de produto analisar a viabilidade. 

 

Temos o Workaround que o marcosmelo citou. 

 

Precisando de ajuda é só chamar! estamos de segunda a sexta no chat para ajudar. 


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • April 17, 2024

Do you have an article in English?


Forum|alt.badge.img+4
  • Author
  • New Member
  • 66 replies
  • April 22, 2024

Hi @Marcosmelo, I hope you are well.  Im not trying to concatenate the values, instead I want to have 2 fields, the one field where I will be able to search user & ones I select User the 2nd field will automatically populate with the Users email on the card


marcosmelo
Forum|alt.badge.img+18
  • Pipefy Legend
  • 1465 replies
  • Answer
  • April 22, 2024

Hi, @TMZ 

See a screenshot I posted in your other question. You can create two text fields with the names: Name and Email, for example. then, you create the automation using a trigger, let's assume it is the trigger when a card is created. Then in the action you choose, update fields, and then you have to choose the fields created Name and email and fill them in with the database information. You select the database that was filled in the initial form, and choose the Name and Email fields to feed the fields you created previously.
I don't know if I managed to explain it correctly.
But if you have any questions, send them here

 

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings