Answered

A numberfield to autoincrement and reset back to 1 monthly

(0) Share

Report

Posted on by CHEWENGCHIN

Hi all,

Is it possible to let a number field autoincrement by 1 when a form is submitted, and it will autoreset back to 1 on a monthly basis?

Thanks! 😁

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @CHEWENGCHIN,

In case your Auto Number each month does not exceed 2000 rows, you could use the following code in the Default property of the Auto Number DataCardValue:

With( { wFirstOfMonth: DateTimeValue( Date( Year(Today()), Month(Today()), 1 ) ), wLastOfMonth: Date( Year(Today()), Month(Today()) + 1, 0 ) + Time(23,59,59) }, CountRows( Filter( //Change datasource to the correct table/list name DATASOURCE, Created >= wFirstOfMonth && Created <= wLastOfMonth ) ) )

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Surendran Ravindran 212 on at

Like (0)

Report
Copy link

Link copied!

@CHEWENGCHIN

Regarding Model driven Apps/CRM

Out-of-box autonumber cant be resetted

So , to Acheive this we have to use Sync Plugin

Maintain a separate table/entity (e.g., AutoNumberConfig) that stores the current sequence, year, and a lock column/field.
The first step in the auto number plugin is to update the lock field (create a new guid) in the AutoNumberConfig record. current will lock the row, such that if another record is produced at the same time, it will be delayed until current row is completed.
Then, in your auto numbering logic, determine whether the current month differs from the last saved month. If so, the series is reset; otherwise, the sequence is increased.
Save the current record and the AutoNumberConfig row with the year and sequence.

Regards
Surendran Ravindran

Was this reply helpful? Yes No
CHEWENGCHIN 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM 😁

Thanks for your help, but the AutoNumber starts from 0 instead 1.

Could you please make it starts on 1?
Thanks !

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi @CHEWENGCHIN,

Glad to help! 😊

We only need a small adjustment to achieve that. Add + 1 after the With() statement:

With( //See previous comment for the full code... ) + 1

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
CHEWENGCHIN 12 on at

Like (0)

Report
Copy link

Link copied!

Hi @LaurensM 😁

Great! It's working now.

Thanks for your help !

Was this reply helpful? Yes No