i want download excel file with these attributes (Name, Phone Number, Email), how to give mandatory to the name and Email attributes fill in that excel
Hello,
What you mean exactly by mandatory? Do you mean export only records that has name and email?
Or do you want to make name and email columns into excel mandatory? If this is the case you can't implement this to downloaded excel from OutSystems or to any excel sheet without using Macros using VBA scripts.
You can check following post for making some cells required in excel sheet using VB:
https://techcommunity.microsoft.com/t5/excel/creating-excel-mandatory-required-fields/m-p/3035173
I would say that a way to "implement" this is to make the fields themselves mandatory on the DB. So in that way, you will always have them on your excel. But other than that, you can't force excel fields to be mandatory when downloaded by outsystems.
Hey,
Do you mean that you want a style such as "*" to the attributes which you have mentioned as mandatory in your entity while downloading an excel?
Hi Mukesh,
In a Customer entity, There are three attributes namely: name, phone number and email (*Name and email are mandatory). The same will be downloadable in the browser by clicking on excel icon. After the excel is downloaded, the user will be able to enter the requested data in Excel sheet, If the user enters the name and phone number without email / email and phone number without name, then the excel sheet does not need to be saved in MS-Excel.
Regards,
Sreenivasulu Reddy Lingala.
Hi @Lingala sreenivasulu reddy,
Am not sure about handling this scenario on the excel side but this can be handled in OS by just having Phone number has a mandatory field and if required you can add custom validation before saving them to DB.
Thanks,Vignesh Prakash.