Create A To Do List (Milestone Task List)

[ichilddev]

We are creating a list for the designated user to follow up:

1. List ID in the Task Table will be created if one of Confirmation Record in the Confirmation Table’s column If_Local = “Need Work Pass”;
2. This List ID will have a list of follow up tasks to be perform by the Admin
3. To Relate this List ID back to this Confirmation Record

How can we generate this Task (task ID) without using Google Sheet arrayformula automatically?

Currently we are using Google Sheet to generate the Confirmation Record Unique Id in this format P22XXX via arrayformula.

[Darren_Murphy]

How do I create an auto-incrementing row number with Glide Tables?

This is a question that comes up a lot, so creating this topic to use as a reference. Typically, there are two distinct use cases when it comes to auto-incrementing row numbers. Use Case 1: – We need to generate a Part Number, or an Order Number, or an Employee ID. Once the number is generated, it should never change, even if rows are deleted. – The general approach for this use case is to maintain a static counter, use it to craft a suitably formatted ID, and increment it by one every time…

[ThinhDinh]

One important point from Darren’s method that you should note is:

Once the number is generated, it should never change, even if rows are deleted.

This will make sure that your IDs are static and safe. If you want to use these IDs in other relations but accidentally delete one of them, the IDs will be shifted and you will lose your relations.