Jump to content
  • 0

Use Formula Field Value with Duplicates to In Another Field with the Nth Iteration Indicated


cordova
 Share

Question

Hi,

 

I want to create a formula field (that puts last name and first name next to each other) and set this as unique, but I can’t seem to make this unique since apparently some of my records have the same first name and last name. Is there a way for me to mark each duplicate records with their nth iteration? For example:

 

First_Name         Last_Name         Complete_Name              Complete_Name_Nth_Iteration

John                      Doe                       JohnDoe                             JohnDoe

John                      Doe                       JohnDoe                             JohnDoe2

John                      Doe                       JohnDoe                             JohnDoe3

 

If ever I was able to make the Complete_Name_Nth_Iteration, I could then finally set that field to unique, but I’m not sure how to achieve this.

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

You can do this with the use of Task so it checks all the existing records and create the Complete_Name_Nth_Iteration value for each record.

image.thumb.png.7ccf0eec5750c593633813994756c578.png

image.png.318b865d0f11753b651d3694ca9f7183.png

 

You can then set this new field into unique. However, since this action is ran using a Task, it does not ensure that newly inserted records will have a Combined_Name_Nth_Iteration value (and since Unique fields cannot be null), so what you can do next is create a Triggered Action that creates the Combined_Name_Nth_Iteration for every inserted data.

image.png.7da8dec1c6941030218783b7231629f5.png

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...