Skip to content
Euro Softworks
Euro Softworks
IT Company
  • Home
  • Company
    • Our team
    • References
    • FAQ
  • Services
  • Products
  • Blog
  • Career
  • Contact
FacebookTwitterLinkedinInstagramMail
  • Home
  • Company
    • Our team
    • References
    • FAQ
  • Services
  • Products
  • Blog
  • Career
  • Contact

Action button column mapping

In Vistos CRM, all fields that are share keys are automatically transferred using the action button (for example, the Name field on Order Received will be transferred to the Name field on the Invoice issued). However, if we want to transfer a field with a different key we will use the Column Mapping feature on the action button. At the same time, this feature allows you to set the default value for a specific field. If we create a new record on any entity, using pre-filled fields when the fields will stay the same (for example, identical or pre-filled with an enumeration) our work will be much easier as we do not need to fill out repetitive information every time we record.

Copy information from one field to another

If I want to copy data from a field in one projection, and into a field on another on another projection (fields must be of the same type)

  • Name: Format convention: Projection from which we want to copy the data; hyphen; the column of the data; underscore; the projection to which we want to copy to; hyphen; the column to which I want to enter the information (e.g., I want to copy the name to the subject email: Contact-Name_Email-Subject);
  • Source column: The column from which want the data;
  • Target column: The column to which I want to copy the data to;
  • Action button: The action button to we are mapping (from which entity to which entity);
  • Custom: Select Yes (created by user, not a system).

Removing automatic transfer of information from identically named fields

In order to cancel the transfer of data that we do not want to be copied, we first have to find out which column is being copied to. If the fields on these entities have different keys, delete the appropriate record in the column mapping list. If the fields are named identically on both entities, they are automatically copied and, on the contrary, a new column mapping should be created to cancel the mapping. Create the mapping in the same way as before, though we will set the Default value to “NULL”.

Automatically preloaded fields when creating a new record

If we would like to create a new mapping for preloaded data. we will enter the mapping as follows:

    • Title: Format convention: Hyphen; underscore; the projection on which the relevant field is located; the column we need (for example, the Payment Currency field would be named: -Payment-Currency_FK);
    • Source column: Leave blank;
    • Target column: the column we need;
    • Action button: I choose the action button that starts with “New” (e.g. New__Payment);
    • Custom: I select Yes (created by a user, not a system);

 

  • Default value: type SQL statement (e.g. [SELECT TOP 1 ss [DefaultCurrency_FK] FROM [crm].) [SystemSettings] ss WHERE ss [Deleted] = 0)

 

Copy an active entry to the Entity field

It may be necessary to copy, for example, the product’s currently open record to the Product field (Product_FK) on a Case entity. To do so, we use the id of the record in the column mapping. The name would be in the form of “Product-_Case-Product_FK”, which symbolizes the parent projection, hyphen, underscore, child projection, hyphen, and the foreign key column on the target projection. We leave the source column blank, the action button we are mapping “CreateFrom_Product_Case”, the target column would be a field with the given entity, for this example Product_FK. An important point is to fill the default value with “@id”.

Note

In order to map the column, you must first have created the appropriate’ action button.[/vc_column_text]
Category: VistosCRM Tips & TricksBy eswadminNovember 13, 2018

Author: eswadmin

Post navigation

PreviousPrevious post:Action buttonsNextNext post:Action button – add/remove

Související příspěvky

Alerts to the user
November 16, 2018
Alerts in the menu
November 16, 2018
Generate a Tax Document for an Invoice
November 16, 2018
Search
November 16, 2018
Action buttons
November 16, 2018
Kategorie článků
  • General(1)
  • VistosCRM Help(23)
  • VistosCRM Tips & Tricks(6)
Poslední komentáře
    V čem jsme dobří
    Zabýváme se mnoha odvětvými ve světě informačních technologií.
    Programování
    Implementace
    Konzultace
    Audit
    Reference
    • We have chosen Vistos CRM from Euro Softworks s.r.o.  as a comprehensive CRM solution that enables us to manage customer information from partners in our service concept, including the ability to create subdivisions. We mainly appreciate the built-in features for data cleaning and validation, automatic addition of information from the business register and reporting tools. Vistos CRM is a good tool for managing business not only with focus on customers.

      Lukáš Štelcl
      Manager of service concept ACC – Stahlgruber
    • Euro Softworks helped us at the beginning with the establishment of Salesforce licenses for nonprofit organizations. We appreciate responsive approach while setting up our customizations and we would like to express that we are satisfied with the selection of our Salesforce partner. We are happy to further recommend this company.

      UložitUložit

      Roman Novotný
      Member of supervisory board, Bátor Tábor
    • We were facing problems with ineffective setup automation in Salesforce for a long time. Thanks to the Euro Softworks audit, we got an overview of the stage of all automation in Salesforce instance. We also highly appreciate the proactive approach in consultations.

      UložitUložit

      Jan Škapa
      IT Director, Students For Liberty
    • For our entire company, I can say that Vistos CRM from Euro Softworks s.r.o. became for us an essential and important part of our business. It greatly facilitates our work, saves time and allows us to monitor, how we are doing in terms of sales. It also helps us with planning work and its distribution among employees. We appreciate the clarity of the system, the ability to filter by order parameters and we also appreciate quick search. We can just recommend Vistos CRM.

      UložitUložit

      Petr Coch
      Executive director, AVANTICA
    • Vistos CRM from Euro Softworks s.r.o. helps us to deal with our customers, we actively use it to create and plan marketing activities, track the development of individual stores and much more. Since it’s implementation and for the time of using the system, we are very satisfied with it. A great advantage for us is the possibility to customize Vistos CRM at any time according to our needs. We also appreciate the proactive approach of Vistos CRM support.

      UložitUložit

      Denisa Vacíková
      Consultant, trainer and project coordinator in MgC Consulting
    • We have been using CarRental system from Euro Softworks s.r.o.  since 2014 and we are happy with it. CarRental significantly helps us with the car rental operation, it facilitates work with clients and the administration of the whole car rental business. Programmers from Euro Softworks s.r.o. tailored an application for us, where we can easily and quickly record short and long rentals of our vehicles for corporate clients. The system has brought our car rental companies into a better overview and increased the efficiency of our employees’ performance, who are spared the lengthy filling of paper or excel forms and spreadsheets.

      UložitUložit

      Stoszková Kateřina
      PLPM a.s.
    QUICK INFORMATION

    E-mail:
    info@eurosoftworks.com

    The time we are online:
    Monday - Friday 09:00 - 17:00

    Customer service:
    +420 774 604 700

    Send a message

    FROM OUR BLOG
    • Alerts to the user

      Notification give users a report on their activities and their dates. They are located at the top right, next to the user’s portrait. E-mail The green color displays the number of unread emails to the user, where we click on the icon to preview the last five emails . Cases The notifications give an overview of the number of cases handled by…

      November 16, 2018
    OUR PROJECTS
    Euro Softworks

    Copyright 2020 Euro Softworks s.r.o.

    Do you have a question? Do not hesitate to write to us!