Is there way to Update an Existing Entry/Ticket Number via Form


IE i have an Automated Number populating in one cell (Creating a Ticket Number)

What i would like to do is in Forms. Create a toggle with logic that says if its new then create a new automated number. If it is an existing number then look it up in the list and replace it.

Initial try is that had: One column for automated numbers, One Column for Existing Numbers, one column for New or Existing, then had a rule if New then use the automated column and if Existing use the ticket number that was entered from the form (via logic). to create a seperate column for True Ticket numbers. Here is where i ran into issues is searching and replacing the column that matches that number. Any suggestions?

Best Answer