Duplicate custom fields entry?

SnowCat asked a question.

November 8, 2018 at 8:00 AM

Hi all!

I was wondering if there was a back end method of copying a custom field?

Basically, i have duplicates in a custom field so was hoping to add them as secondary custom fields so they all show.

The only issue is, there are many many many many options (well over 100) and it will be time consuming to set all the multi-selects up for a second and possibly 3rd custom field.

We are hosted so it's not something i can check myself so i just wanted to see if there was an easy way of this being set up so i dont have to spend my days adding them all!

Thanks,

Gemma

Viktors
8 years ago
Hi ‌! I guess it can be done from the back-end (SQL query). I have tested the following query for our demo: insert into tblCustomField ( cid, CategoryID, Name, ValueDataTypeID, IsMandatory, MultipleChoice, CreatedBy, UpdatedBy) values ( 1 , 2 , 'SQL insert' , 3 , 0 , '10,9,8,7,6' , 'Viktors Vasiļonoks' , 'Viktors Vasiļonoks' ) --CID: customer id --CategoryID: custom field category (1 - User, 2 - Computer/Mobile device, 3 - License, 4 - Agreement, 5 - Application) --Name: custom field name --ValueDataTypeID custom field type (0 - Text, 3 - Digit) --IsMandatory custom filed is mandatory (0 - No, 1 - Yes) --MultipleChoice custom field multi select (comma separated) --CreatedBy custom field created by --UpdatedBy custom field updated by‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ ‍ As a result, I have got this: SLM side: Computer section: Best regards, Viktors
Expand Post
- SnowCat
  8 years ago
  Oh my gosh Viktors, that's absolutely amazing and the perfect answer to my question. Thanks very much for all your efforts here, I will definitely ask our hosting party to add this for us!! Thanks again, Gemma
  Expand Post
  - Viktors
    8 years ago
    No problem, Gemma! Glad to help you! Regards, Viktors
    Expand Post

Related Product Forums

→ Flexera One

→ Snow Atlas

→ FlexNet Manager

→ Snow License Manager

→ App Broker

Need help finding an answer?

Ask a Question →

Duplicate custom fields entry?