So, the need of the application is that we generate a unique Provider ID(in screenshot 2 last 5 digits).
Currently when I am uploading an excel file and parsing it. Its creating a Intake-##(number) and creating a ProviderID. Now, the last 5 digits are suppose to be incremental and increment on both the records created (home-1185 and home-1186), instead it is currently getting mapped to Intake number and the last digits are remaining same even if there are multiple records in the excel sheet.
Can you please me with the changes
I have attached in details screenshot, any help will be appreciated
***Edited by Moderator Marissa to update platform capability tags****