filling in an additional field type date in contact cards
Hello, there is an additional field in the contact card f444
There is an excel file with the contact id columns, and the date that needs to be copied into the van box field f444
1. option to manually open each card and fill in the field
2. What tool can automatically fill in this additional field f444 based on this Excel file?
thanks in advance for your reply!
Original question is available on version: ru
There is an excel file with the contact id columns, and the date that needs to be copied into the van box field f444
1. option to manually open each card and fill in the field
2. What tool can automatically fill in this additional field f444 based on this Excel file?
thanks in advance for your reply!
Answers:
Hello!
You can update contacts through the Import/Export Contacts application.
Find contacts by ID and update their value in field f444.
IMPORTANT! In Excel, by default, the format in the cells is not correct, so you need to specify the format of the Date cell in the cells where the date is stored, there will be examples of how the date will look after changing the format. You need to specify exactly the same format as in the system, namely YYYY-MM-DD .
It is also desirable to change the format in this order:
1. Cut the column with dates and paste it into any txt file
2. Change the cell format in excel as I described above
3. Insert dates from txt file into the column where the format was changed
4. Save the file and upload to the system
You can update contacts through the Import/Export Contacts application.
Find contacts by ID and update their value in field f444.
IMPORTANT! In Excel, by default, the format in the cells is not correct, so you need to specify the format of the Date cell in the cells where the date is stored, there will be examples of how the date will look after changing the format. You need to specify exactly the same format as in the system, namely YYYY-MM-DD .
It is also desirable to change the format in this order:
1. Cut the column with dates and paste it into any txt file
2. Change the cell format in excel as I described above
3. Insert dates from txt file into the column where the format was changed
4. Save the file and upload to the system
14.12.2021, 11:12
Original comment available on version: ru
Please join the conversation. If you have something to say - please write a comment. You will need a mobile phone and an SMS code for identification to enter.
Log in and comment
Copyright © OneBox 2024
