Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

How to make field mandatory

Posted on by 86

Hi Experts,

I want to make a field mandatory for the customer group "CFR". Kindly PFA screenshot this field i want to make mandatory. Please help thanks in advance.

0572.ex.png

Regards 

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to make field mandatory

    Hmm seems you need to get the day from the date - month name from the date - year from the date - after that concatenate all the 3 fields using "+" operator.

    mthName(mthOfYr(ShipmentDate))-this gives you month name.

    dayOfMth(ShipmentDate) - will give you date.

    year(ShipmentDate) - will give you a year.

    Assign the output to each string variables.

    Now concatenate all the 3 variables using + operator.

    temTable.ExIndianDate =str1 + " "+ str2 +" "+ str3;

    Thanks,

    Girish S.

  • ax.tech Profile Picture
    ax.tech 86 on at
    RE: How to make field mandatory

    Hi Girish,

    I have checked   ChequeDp class but I have got any expression for  date like 01 january 2022. I want month to be in letters not in number format. Please help

    Regards

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to make field mandatory

    Using expression or through dp class?

    If its via dp class have you refer to ChequeDp class for date format?

    Thanks,

    Girish S.

  • ax.tech Profile Picture
    ax.tech 86 on at
    RE: How to make field mandatory

    Yes after concatenation value is coming like 01/12/2022 but i want like 01 december 2022

    Regards

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to make field mandatory

    Does the concatenation of date and enum fields works?

    You mean while concatenation need to change the date and enum as mentioned above?

    Thanks

    Girish S.

  • ax.tech Profile Picture
    ax.tech 86 on at
    RE: How to make field mandatory

    Hi Girish,

    If i want to change date format from 321 to like 01 january 2022 how can i do that?

    and if i want to first enum to be blank in a report how can i do that ?

    please help

    Regards

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to make field mandatory

    I guess this won't work since its outside of the Tablix. You need to go with adding code in the dp class.

    For date2str refer to class ChequeDp - formatDate(method). Refer to this method for how to use date2str and compare it with your code.

    Thanks,

    Girish S.

  • ax.tech Profile Picture
    ax.tech 86 on at
    RE: How to make field mandatory

    I have restored the dataset still getting the errors. I am adding this in the expression of the textbox in design. Kindly PFA screenshot.

    plm.png

    Regards

  • GirishS Profile Picture
    GirishS 27,832 Super User 2024 Season 1 on at
    RE: How to make field mandatory

    Try to restore the dataset and check. Also, where you are adding this expression? Inside the Tablix?

    Thanks,

    Girish S.

  • ax.tech Profile Picture
    ax.tech 86 on at
    RE: How to make field mandatory

    Got this error. Kindly PFA screenshot

    48131.error.png

    Regards

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans