The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.

Generate list of file titles with one variation depending on user selection

posted Aug 30, 2020 3:38:38 PM

Topic Labels: Formulas

0 812 0

I’ve been trying to figure out how to make this crazy formula happen, but I’ve hit a wall. Can it even be done? Check out below and let me know how you’d accomplish such a thing…

In the base, users select from a list of deliverables via a linked record field that contains everything a client can order for a particular asset (InstagramAd, SnapchatAd, Master, etc.) Each deliverable has a generic file title that follows a specific convention:

Everything between the exclamation points is replaced with information specific to the asset when the deliverable is chosen on the Order table. So the above generic file title auto-generates this asset-specific file title:

Figured it out :slightly_smiling_face:

0 Replies 0