Filename help sometimes causes duplicates in App

[pvara]

I have built an app where and I am capturing "Filename" once the user inputs their file.

The rub is sometimes in the users raw file, there is a column called "Filename". Is there a way to ignore if "filename" exist in the raw file?

Currently I have been going in manually and modifying the name.

I tried creating a formula but if filename2 does not exits it breaks.

[fmvizcaino · Accepted solution]

Hi @pvara ,

Since you already developed a way with a formula, the best way to tackle is to always create a filename2 is it doesn't exists.

Example attached.

Best,

Fernando Vizcaino

[pvara]

thank you this solves a manual problem.