Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

Topic Labels: Formulas
299 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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