Need to make the required text bold

Hi Vivek,

You can made changes in the template and add one more field for value which is required or not by having the temporary CDT for that. You can have true/ false for this and according to this true/false, populate the BOLD values and hide the required column from the template.

Please let me know if it works or not.

Hello Arpit,

Thanks for your reply but I didn't get it, Actually I'm using just an excel sheet as a template without having any data or validation inside it. Lets say I add one field in the template then how do i make the text bold or normal based on my current CDT because there might be multiple fields which are required or not, I'm totally confused. Sorry but can you elaborate something more or provide any such good examples?

Hello Arpit,

Thanks for your reply but I didn't get it, Actually I'm using just an excel sheet as a template without having any data or validation inside it. Lets say I add one field in the template then how do i make the text bold or normal based on my current CDT because there might be multiple fields which are required or not, I'm totally confused. Sorry but can you elaborate something more or provide any such good examples?

Hi Vivek,

What I want to say,
1. Create a temporary CDT which will hold one boolean field is required or not.
2. So when you will generate the excel from the CDT, use the temporary CDT and have this field in the template as well.
3. Now according to this field let suppose in D block of Excel and and the value for the required field in E, then create a new column F in excel template to have function which will check the true and false and on the basis of that show it as bold in the excel template.

Make sure for F column to add in the temporary CDT as well. and hide the C and D for that.

Please let me know if you understand this

Hey Arpit,
Let me explain what I understand. Assume I have below CDT(Original CDT)

CDT:[Label:"ABC", Required:1],
[Label:"PQR",Required:0],
[Label:"XYZ", Required:0],
[Label:"LMN", Required:1]

Where required 1 means needed and 0 means not needed, So the second CDT which I will create for storing true/false would look something like

CDT2:[Required:true],
[Required:false],
[Required:false],
[Required:true],

Because my original CDT has 1st and 4th field as required, So it would be True,False,False and True.

Now I will export both the fields in excel i.e Column "Label" from my original CDT and column "Required" from another CDT. After moving the value in excel sheet, I will place it like

ABC true
PQR false
XYZ false
LMN true

and I will use excel function to check the values in other column. If it is true, I will make the Label Bold and if its not I will keep it in a normal font. Did I understood the concept correctly?

Yes Vivek