Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How to access getNextObjNumberPadded() in a client script?

MichaelZischeck
Kilo Sage

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)?

6 REPLIES 6

amittani03
Tera Contributor

Me gustaría generar un incremental pero que se muestre como primer registro 0000001, y luego 0000002 y así sucesivamente. 

Hola @amittani03, para poder crear un incremental sucesivamente, primero debes crear un desde la misma tabla activando en auto-number.

FranciscoAngul_0-1761832754961.png

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();

FranciscoAngul_1-1761832839711.png


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 !