Dynamics Community Forum Thread Details

Data should not be update in uneditable field and existing value in field not change through excel add-in

In my requirement I have a unedited able field in which user cannot enter values of form after if this field is lock. Below in picture the Jul-22 field is lock and unedited.

I want when I update data through excel add-in specifically field Jul-22 value cannot be ever changed with any new value or field value replace its already existing value like 170. Below in picture period 1 is Jul-22 field in excel If user remove 170 and put 180 so the 170 should exist in table and 180 value not updated.

  select * from projectForecastPeriods
            where projectForecastPeriods.FinancialYear == this.FinancialYear
            && projectForecastPeriods.ForecastModel == this.ForecastModel;

        if(projectForecastPeriods.Period1 ==NoYes::Yes && this.Period1)
        {
            ttsbegin;
            select forupdate currentForecastTable 
                where currentForecastTable.RecId == this.RecId;
            currentForecastTable.Period1 = this.Period1;
            currentForecastTable.update();
            ttscommit;
        }

I try the above code on Data Entity level method mapEntityToDatasouce in which I assign existing value to my table . In this case its assign value to table feld but its thrown a error on currentForecastTable update method "The record never been selected" and in this way its update the field value with new value. This code not working properly.

Please give me suggestions.

Thanks.

Quick Links

Leaderboard