How to access getNextObjNumberPadded() in a client script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2023 06:25 AM
I am going nuts here.
Could be I miss some basic stuff. Please try to help
Issue:
I want to create multiple records at once. Works using Import XML. I can preset all values the way I want them.
What does not work is: creating the number for those records.
I could use a onLoad client script which checks: number set: good, number not set: create one.
So I searched a lot and came accross:
getNextObjNumberPadded()
global.getNextObjNumberPadded()
new global.NumberManager().getNextObjNumberPadded()
new global.NumerManager('table_name').getNextObjNumberPadded()
new global.NumberManagerGlobal('table_name').getNextObjNumberPadded()
Problem is: none of these work. I can't seem to get hold of global.
Not even glide.script.block.client.globals = false will help
what I want to know:
can I use: getNextObjNumberPadded()? If not, can I use a catalog script (I understand this is more backend?) to achieve a similar effect (generating of missing numbers)?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-22-2023 10:05 AM
Me gustaría generar un incremental pero que se muestre como primer registro 0000001, y luego 0000002 y así sucesivamente.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 weeks ago
Hola @amittani03, para poder crear un incremental sucesivamente, primero debes crear un desde la misma tabla activando en auto-number.
si quisiera hacerlo manualmente, debes ingresar a la tabla sys_number y luego poder acceder a esta tabla desde un campo creado con el script : javascript:global.getNextObjNumberPadded();
para manejar la cantidad de numeros que debe tener lo manejas de la tabla
sys_number
y para manejar la cantidad de registro en la que vas tienes que revisar la tabla sys_number_counter
saludos !
