Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Field appears as column in Views but values are all empty

(0) ShareShare
ReportReport
Posted on by 325

The values of some of the fields I created on the Order Form do not appear in any Views; the columns are empty. This although the attributes exist, the fields on the form are correctly linked to the attributes, the values in the fields on the forms contain non-zero values and the correct columns are added to all Views.

The fields correctly appear as columns in the Views, but these columns are all empty.

Any clue anyone ? 

*This post is locked for comments

  • Kelvin Aston Profile Picture
    35 on at
    Re: Re: Re: Re: Re: Field appears as column in Views but values are all empty
    Thanks for the reply Niko, Unfortunately my fields aren't read only so I'll have to continue the investigation. Cheers Kelvin
  • Niko Bel Profile Picture
    325 on at
    Re: Re: Re: Re: Field appears as column in Views but values are all empty

    Hi Kelvin,

    Peter Jaeckel provided the solution as you can read in the thread. The fields must no be read-only, otherwise they will not be sent to the database on form submit.

    Cheers,

    Niko 

  • Niko Bel Profile Picture
    325 on at
    Re: Re: Re: Re: Field appears as column in Views but values are all empty

    Hi Peter

    Thanks a lot, this is it! I made the field read/write, opened and saved a few orders and saw the fields getting filled before my eyes. All (-; I now have to do is to go trough all orders and open/save them to submit the values to the database 

    Although it did solve this problem, can you tell me where I can read a bit more about the background of this ? I am still somewhat intrigued.

    You are you saying because the field is read-only, it's value is not sent during a form submit. Because the assumption is that no change can occur to a read-only field ? And the database will always hold the initial value (null). And if I somehow (by a script) manipulate a read-only field value, it should not reach the database either ? Why does a form reload then show the new value ? Do the onchange scripts run at form load ? Or is there a cache somewhere in between that fools me ?

    Thanks again

    Niko

  • Kelvin Aston Profile Picture
    35 on at
    Re: Re: Re: Field appears as column in Views but values are all empty

    Hi Niko

    I have the same thing with Phone Call activities - please let me know if you have any luck solving this. I've also found that I DO see the data if I look at the same view using advanced find. Do you find the same?

     

    Kelvin

  • Leon Tribe Profile Picture
    7,034 on at
    Re: Re: Re: Field appears as column in Views but values are all empty
    This issue I was thinking of was fixed up in rollup 1 or 2 I think so this is obviously something different. Good luck. Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
  • Peter Jaeckel Profile Picture
    20 on at
    Re: Re: Re: Field appears as column in Views but values are all empty

    Hi Niko,

     try setting 

    crmForm.all.linx_calctcv.ForceSubmit = true;

     Since thi is a read-only field CRM does not send its value during submit.

     

    Ciao,

    Peter

  • Community Member Profile Picture
    on at
    Re: Re: Re: Field appears as column in Views but values are all empty
    Niko, just a thought : what if you would parse the result to an Int in Javascript? Only if the linx_calctcv field is an Int of course... Haven't tested this on my VPC it's just a wild guess....
  • Niko Bel Profile Picture
    325 on at
    Re: Re: Field appears as column in Views but values are all empty

    Dear Leon,

    Thanks for your quick reply. We were at roll-up 4 and ran roll-up 5 over the weekend. Unfortunately it did not change CRM's behavior; the fields shown on the forms do contain values, but in the views there are still no values in the respective columns.

    Some additional info that may be helpful: I calculate the value of one of these fields, linx_calctcv by multiplying the values of 3 other fields (linx_nrc, linx_mrc and linx_term); the onchange script of these 3 fields is shown below.

     var term = crmForm.all.linx_term.DataValue;
    var nrc = crmForm.all.linx_nrc.DataValue;
    var mrc = crmForm.all.linx_mrc.DataValue;
    var result = term*12*mrc + nrc;
    crmForm.all.linx_calctcv.DataValue = result;

    As soon as a user changes one of the 3 fields, the correct value of linx_calctcv appears in linx-calctcv on the order form. I would now expect any view in which this order record appears to show this value as well, but no.

    This field is read-only, so a user cannot change it directly, but I don't think this should cause the above problem. 

    Again, any clues ?

    Thanks

    NB 

  • Leon Tribe Profile Picture
    7,034 on at
    Re: Field appears as column in Views but values are all empty
    This is a known bug and fixed up in the rollups. Leon Tribe Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,933 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,801 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans