Hi,
I am a new user of BC3. I have tried searching online for an answer to my problems but to no avail.
I have to compare two excel files and update one with the changes in it. (The files have only 2 columns in them. An ID and its Title) The changes that are made need to be highlighted in the excel so that I know what ID needs to be changed in the system. My problem is that I am not able to highlight the rows in excel using BC.
To get around this issue, I created an extra column where I thought I would enter an identifier (eg a letter) in the rows that are updated and later on filter that column with the identifier to have all the rows that were updated and highlight them. The problem I am facing is that I am unable to enter any information in the records in BC3. It lets me move the records or delete them, but I cant change one particular cell. Can I do that? Does BC3 have this functionality? Is there something very simple that I am overlooking?
FYI, since BC3 dosent allow editing of xlsx files, I saved them as csv and used those.
Any help would be appreciated. Thanks.
I am a new user of BC3. I have tried searching online for an answer to my problems but to no avail.
I have to compare two excel files and update one with the changes in it. (The files have only 2 columns in them. An ID and its Title) The changes that are made need to be highlighted in the excel so that I know what ID needs to be changed in the system. My problem is that I am not able to highlight the rows in excel using BC.
To get around this issue, I created an extra column where I thought I would enter an identifier (eg a letter) in the rows that are updated and later on filter that column with the identifier to have all the rows that were updated and highlight them. The problem I am facing is that I am unable to enter any information in the records in BC3. It lets me move the records or delete them, but I cant change one particular cell. Can I do that? Does BC3 have this functionality? Is there something very simple that I am overlooking?
FYI, since BC3 dosent allow editing of xlsx files, I saved them as csv and used those.
Any help would be appreciated. Thanks.
Comment