Skip to main content
Solved

Autofill customer information from database

  • January 11, 2021
  • 2 replies
  • 356 views

jd12
  • Regular Participant
  • 1 reply

I am having a great deal of difficulty using the connection mechanism to autofill fields on a card from information in the database (I assume this can be done). I have created the connection and linked the fields and ensured the fields are of the same type in both the database and the card.

 The cards will track installation jobs from quote through installation and I don’t want to add a recurring customer’s information into the card every time a contractor needs another job. I want to select their record from the database menu and have the fields on the card reflect that customer’s contact information (phone, email, name, etc.).

I have created the fields in phase 2 and I make the connection in phase 1, but my test customer’s contact information never populates in the card’s fields.

Best answer by Roberto Chavarria

Hello! To do this action, you’d have to create an automation to do this, as the autofill only fills in Database records with information from cards, and not vice-versa. 

Here’s an example of such automation:

 

In this example, I’m filling the pipe’s short text field with a short text field from the record that was selected. To have this automation work, that database connection field must already be filled out.

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

2 replies

Roberto Chavarria
Pipefy Staff
Forum|alt.badge.img+5

Hello! To do this action, you’d have to create an automation to do this, as the autofill only fills in Database records with information from cards, and not vice-versa. 

Here’s an example of such automation:

 

In this example, I’m filling the pipe’s short text field with a short text field from the record that was selected. To have this automation work, that database connection field must already be filled out.


jd12
  • Author
  • Regular Participant
  • 1 reply
  • January 19, 2021

Thank you Roberto! I was able to follow your procedure successfully. 


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