Reply
Highlighted
Member
Posts: 108
Registered: ‎09-27-2013
Kudos: 67
Solutions: 6

SQL enhancement for custom ID

Howdy,

 

would it be possible to have a default value for client.user_ident? Ideally (for me ) a sequence that increments a alphanumeric value.

(like xb7-00001)

I am afraid, if simply do that myself, in case of an upgrade it would be overwritten

 

Thanks

Oskar

Ubiquiti Employee
Posts: 3,724
Registered: ‎12-10-2015
Kudos: 1325
Solutions: 292

Re: SQL enhancement for custom ID

[ Edited ]

We plan to do this, but currently, this is not enabled. Only numeric values are auto-incremented. You can create or upvote existing request here https://community.ubnt.com/t5/UCRM-Feature-Requests/idb-p/UCRM-Ideas to keep this idea alive.

 

You can also consider avoiding the prefix. If you hardcode the prefix to the invoice template (or other templates), you may use only the numeric values which would be appended to the prefix in the template...

Member
Posts: 108
Registered: ‎09-27-2013
Kudos: 67
Solutions: 6

Re: SQL enhancement for custom ID

@UBNT-Petr,

 

I was thinking about the prefix.

However, it is meant - in case of multiple organizations - to create a human readable  foreign key into Quickbooks

 

But, anyways thanks for considering

Oskar

Reply