This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Lansweeper Community
- Forums
- General Discussions
- How to set a default value for a custom field?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Register to ask a question, start a topic or share an idea
Join the Community
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-05-2016 04:08 PM
I'm using the beta version of LS, 6009. But, I'm sure the functionality is the same. I want to create a custom field using the yes/no option, but I want to set the default value to "no" for all assets. Is this possible? Thanks.
Solved! Go to Solution.
Labels:
- Labels:
-
General Discussion
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-05-2016 08:30 PM
Unfortunately, there is no built-in functionality at the moment to set a default value for a custom asset field. I believe this feature has been requested by another customer as well and is on the wish list, but we don't have an immediate release date.
You could create a trigger for the relevant table (tblAssetCustom) in SQL Server Management Studio, so that the custom field is updated to the value of your choice when the asset is first inserted. This is not something we can provide instructions or support for however, as any custom database changes can potentially break your installation and are made at your own risk. You can also edit the custom field value of all existing (though not future) assets at once, by clicking the Assets link at the top of the console, ticking the upper checkbox and hitting the Mass Change button on the left.
You could create a trigger for the relevant table (tblAssetCustom) in SQL Server Management Studio, so that the custom field is updated to the value of your choice when the asset is first inserted. This is not something we can provide instructions or support for however, as any custom database changes can potentially break your installation and are made at your own risk. You can also edit the custom field value of all existing (though not future) assets at once, by clicking the Assets link at the top of the console, ticking the upper checkbox and hitting the Mass Change button on the left.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-05-2016 08:30 PM
Unfortunately, there is no built-in functionality at the moment to set a default value for a custom asset field. I believe this feature has been requested by another customer as well and is on the wish list, but we don't have an immediate release date.
You could create a trigger for the relevant table (tblAssetCustom) in SQL Server Management Studio, so that the custom field is updated to the value of your choice when the asset is first inserted. This is not something we can provide instructions or support for however, as any custom database changes can potentially break your installation and are made at your own risk. You can also edit the custom field value of all existing (though not future) assets at once, by clicking the Assets link at the top of the console, ticking the upper checkbox and hitting the Mass Change button on the left.
You could create a trigger for the relevant table (tblAssetCustom) in SQL Server Management Studio, so that the custom field is updated to the value of your choice when the asset is first inserted. This is not something we can provide instructions or support for however, as any custom database changes can potentially break your installation and are made at your own risk. You can also edit the custom field value of all existing (though not future) assets at once, by clicking the Assets link at the top of the console, ticking the upper checkbox and hitting the Mass Change button on the left.
New to Lansweeper?
Try Lansweeper For Free
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now
Related Content
