Notifications
Announcements
No record found.
Hi there, we got an requirement to create a new Data entity based on VendTable which will be having newly added fields in VendTable Extension. Here as per our requirement, we need to allow update for those fields only from Data Management import only and not from open in excel option. How can we achieve that as when i make the property allow edit - false, import process is getting failed and records are not updating but update from open in excel is preventing as expected. Please suggest what we can do for this?
thanks in advance
Hi,
I think for this one DMF and Odata entity might have rather similar sequence then you might think of customization logic but seem tricky. I would recommend to duplicate and create 2 entities, 1 for DMF and 1 for OData and use security control to limit the access.
Regards,
Hi Alex, as per our requirement we need to do the development in only one entity itself. Can we add any logic to the table to make fields as uneditable or is there any other way to restrict it from Open in excel option itself. Please suggest
HI @Prem,
Can you try to set access modifier as internal on your newly added field and check ? if you don't want to see the fields in excel add-in.
I have checked for custom entity and it is not available in excel add-in but I can do import using DMF.Hope this will help you.
Hi Vijay, we want to see the new fields in open in excel option. And how can i make it as editable in DMF import and uneditable when open in excel? Can u be more specific
It can be achieved with security roles assigned to users, this will have an effect in both data management and excel. Assign user role of view only. and keep the edit role only to user who will update the data through Data management.
Hi, can we prevent by adding any logic in Entity posttarget() or any new method in table to make field as uneditable ?
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 565 Most Valuable Professional
André Arnaud de Cal... 450 Super User 2025 Season 2
Sohaib Cheema 250 User Group Leader
