Possible to reset increment number by formula

[shalmaxb]

Hello, as the subject says: Is it possible to reset the next number in number field by formula?

[abidoss]

Try to do it with the "Advanced" pack using a workflow

[shalmaxb]

I do not have advanced pack

[victor]

shalmaxb,

Please describe your purpose. Perhaps, under certain conditions of record creation, the field with the type Number (auto-increment), or maybe the field with the type Auto-increment remained empty?

[shalmaxb]

I have an entity, where records from another entity are displayed in a 1:n relationship. The number of these records may vary (maybe 10 records or 100....).
I want to number theses records, always beginning with 1 and ending with the last number depending on the amount. If I use one of the auto-increment fields in the related entity, it numbers the first group of records for example 1 to 10, but the second record group would be 11 to n. I want this second group starting again from 1.
I tried with a workaround: When the first group of records had been auto-incremented 1 to 10, I copied these values into another field (normal integer) and made it non-editable by condition, so it would not be affected, if the auto-increment would be reset. In this case, I would not disply the auto-increment, but only the second integer field, so the user would only see theses copied values, the auto-increment would work in the background.
So I thought, if it would be possible to reset the auto increment on creating a new group of records, to make it start with 1 again, copies these new values to the second field and would be resetted again on creating a new record an so on.

So I am looking for a formula that says: if record create, reset next number to 1.

[item]

Formula :

Entity = NextNumber
EntityType = your entity with auto-increment field
fieldName = your auto-increment field Name

first find the entity with formula :
$id = record\findOne('NextNumber', 'entityType', 'desc', 'entityType=', 'yourEntityType')

then update :

record\update('NextNumber', $id, 'value', 1)


you can too do :

$value = record\attribute('NextNumber', $id, 'value')
if $value > 10 then set value = 1 // of course by formula.

[shalmaxb]

item, thanks. Is there such entity named NextNumber?

[item]

Yes,
Is there all auto increment are store

Use too fieldName= … in entity\FindOne(.. for better

[shalmaxb]

unfortunately does not work. it seems, that NextNumber does not react at all to formula.

[item]

Strange,
In m’y case, i réset each month with a job :

See Yuri response :

https://forum.espocrm.com/forum/developer-help/93267-metadada-change-only-one-value

Give your entity name, your field name… post your formula here

[shalmaxb]

entityName = Exemplare
increment-field = ex

So I want to create one record in Exemplare, which should get the number 1, then another one, which should get the number 2 and so on.

These records link 1:n to another entity, where it appears as two (or more) items in a list with the numbers.

In that entity again I want to create another record, which should have linked records from the first entity, but not the same as for record 1, but new linked records, which can be more for example, record 1, record 2, record 3... These records should be numbered again from 1 to n.

As it is now, the numbers are sequencial, what means, they start for the first two by 1 and go to 2, for the second from 3 to n.

The auto-increment field applies numbers from 1 to n independently of the number of records in the related (second) entity.

[item]

Haaaa ok...
so i understand so :
EntityX 1:n Exemplare

recordAEntityX : Exemplare->ex => 1 to 10
recordBEntityX : Exemplare->ex => 1 to 10
and so..
of course in these case, auto-increment number will fail.
i see 2 solution.
when create recordA .. then directly create 10 record Exemplare and then set value nextNumber to 1

or second solution without auto-increment but with findRelatedOne :

$id = record\findRelatedOne('ParentEntity???', ID???, 'exemplares', 'ex', 'desc')
$maxValue = record\attribute('Exemplare', $id, 'ex');
ifThen($maxValue >= 10,
$maxValue = 0;
)

ex = $maxValue + 1;

i think

[shalmaxb]

I already tried a lot in that direction, I will see tomorrow, if I can construct anything from your proposal. It is really nice, to see your engagement for my problem. Thanks a lot.
The only thing I need is, that I want to get the number of the items filled in automatically. It is not a big thing to do that manually, if there are 10 items, but when I have 100 items, it would be very tedious work.

[item]

strange, for me test on demo.. all work as expected. maybe you talk another type of auto-increment.

$id = record\findOne('NextNumber', 'entityType', 'asc', 'entityType=', 'Account', 'fieldName', 'number');
output\print($id);
$value = record\attribute('NextNumber', $id, 'value');
output\printLine($value);
$result = record\update('NextNumber', $id, 'value', 10);
$value = record\attribute('NextNumber', $id, 'value');
output\printLine($value);

[shalmaxb]

I tried it with my entity and my auto-increment-field, result see screenshot. I guess I still am doing something wrong......

[item]

I think i understand,
you have "database" auto-increment type of field.
this kind of field, must be unique ! it's nomarly primary key index (and ??). You can not have duplicate number.
these kind of field is under "database control", no "application" (i explain so with my english)
see print-screen, i just print-screen from demo

[shalmaxb]

I understand that the same way. Because of that fact, that you cannot have duplicate numbers, I wanted to reset it. Before that I would have copied the first emitted numbers to another field (integer) to preserve the values. This second copy-field I would have made non editable after copying and reset the auto-increment.
Then for the second set of related records the auto-increment would start from one again, the numbers would be copied again and so on. But this also did not work. Does not seem to be possible.

I do not need necessarily an auto-increment field, because I think I could sequence the numbers also by formula. That I see in your last proposal as well. I will see tomorrow, if I get any solution on basis of this.