Hi,
I need some assistance with numbering items in a gallery.
I have 2 tables in Dataverse:
Table 1: Application Table - Unique Identifier is Ticket Number
Table 2: Comments Table - Unique Identifier is Comment Number
Whenever a comment is captured, its updated with its corresponding Ticket number in the comments table.
I have a gallery in the comments page that displays all the comments posted for a specific ticket however, the reference numbers are non-sequential as the comments are posted on different dates and times for different tickets.
Please see below image:
The goals is to display the comment number in a sequential order within the gallery. I have used the approach in the article here however it's not as responsive as I would like it be when posting a new comment. Further to the above, it poses a different problem as the users can download the file in excel and then the sequence will be off again.
Is it possible to create a column within the comments table that will automatically assign a sequential comment number for display within the gallery?
Example (Sequence Number):
| Comment Id | Date Posted | Time Posted | Corresponding Ticket | Sequence Number |
| Comment - 1 | 2024/03/01 | 11:57am | Ticket-1 | 1 |
| Comment - 2 | 2024/03/02 | 12:00pm | Ticket-7 | 1 |
| Comment - 3 | 2024/03/03 | 12:04pm | Ticket-1 | 2 |
| Comment - 4 | 2024/03/04 | 01:00pm | Ticket-5 | 1 |
| Comment - 5 | 2024/03/05 | 03:00pm | Ticket-7 | 2 |
| Comment - 6 | 2024/03/06 | 09:00am | Ticket-5 | 2 |
| Comment - 7 | 2024/03/07 | 05:00pm | Ticket-1 | 3 |
| Comment - 8 | 2024/03/08 | 06:15am | Ticket-7 | 3 |
Any help will be appreciated
Regards,
