I have two objects Grant contract Modification and Grant contract.Here from Grant Contract Modification I have given a master detail to grant contract and each modifications created is available in the grant contract object's related list as in the picture.
But here I have provided it as an auto number and the issue is that the modification when created in one Grant starts with the number 1 and when I create in another grant it starts with the number 2 instead of 1.
So I am asked to use a flow to solve this.I have used a record triggered flow and each time a Grant Contract Modification is created the flow fires and a get record is placed after that to get all the grant contracts.I am stuck now.I have to get all the Modifications inside this and it should be displayed in this format "Mod-number(1,2,3..etc)-GrantContractName for eg:Mod-01-GrantContract01.
I am planning to get the number of modifications by getting the count of records in the getrecords(If I get the number of modifications inside each grant contract) and append it to the Mod. How can I do it using a flow?