Share
Report
199We are transitioning from Canvas apps to Model Driven apps. Many of our tables include a column that has custom sequential numbering. With Canvas apps, we wrote a formula in the app to get the next sequence of numbers, but in Model Driven apps, that seems to be a more difficult task.
What is the best way to make this work using MDA? Would it be a flow, a calculated column or something else?
Here are some examples of what we are looking for:
RFI table. The Request for Information (RFI) table includes a column for "RFI No.". This number is shown as "Job No. - Sequential RFI No. based on the job no." For example if we have two job numbers (22-101 and 22-102) the RFIs numbers would look like this:
22-101-01
22-101-02
22-101-03
22-102-01
22-102-02
22-102-03
Purchase Orders. Our purchase orders have a similar numbering scheme in which we use the job number and then the next sequential number that resets every year. The resetting is less important than including the job number on the purchase order. The important feature of the Purchase order is knowing what the number is before the purchase order is created in the system.
We have other tables that work similarly to the RFI number. So if we figure that out, it would help most of the other tables.
Thank you.
All responses (
Answers (
