I’m currently using AirTable to manage some data. My primary goal is to combine multiple cell values to create a filename based on their contents. However, I’ve noticed that not every filename includes the same elements.
For instance, in the formula below, if the filename lacks a “DynamicSubtitle,” it generates an unwanted double underscore. What can I do to prevent this from happening?
Here’s the formula I’m using:
JOIN(Airline, '_', Trimmed, '_', RatioValue, '_', EpisodeTitle, Language1, Language2, Language3, Language4, Language5, '_', DynamicSubtitle1, '_', VersionInfo, '_', MpegFormat, '', FileExtension)
Thank you for your assistance!
Hey, you might wanna use the IF function for each optional field. Wrap DynamicSubtitle1 and others with IFs to check if they’re empty. It can remove those extra underscores for optional fields. Hope this helps! 
Consider using a compact formula approach where you concatenate only non-empty fields. Before appending each section to your filename, evaluate its content using logical checks. This can be done by checking if a field is not empty using basic IF conditions. For example, if DynamicSubtitle1 is empty, omit it and the preceding underscore. This approach streamlines your filename generation process and prevents the appearance of redundant underscores when fields are absent. Experimenting with nested IF conditions could refine your results further.