Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Team
What have I done wrong here please...
[handles], | |
if(match([knockers], 'slimline_urn','Slim'), |
if(match([knockers], 'urn','Standard'),
if(match([knockers], 'urn_with_spyhole','Standard (V)'),
if(match([knockers], 'slimline_urn_with_spyhole','Slim (V)'),
if(match([knockers], 'ingot','Ingot'),
if(match([knockers], 'horsetail','Horsetail'),
if(match([knockers], 'no_knocker','None','None')))))))),
[letterplates] |
Thanks in advance
Bing
you misplaced the brackets
if(match([knockers], 'slimline_urn'),'Slim', |
if(match([knockers], 'urn'),'Standard',
if(match([knockers], 'urn_with_spyhole'),'Standard (V)',
if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',
if(match([knockers], 'ingot'),'Ingot',
if(match([knockers], 'horsetail'),'Horsetail',
if(match([knockers], 'no_knocker','None'),'None')))))))
you misplaced the brackets
if(match([knockers], 'slimline_urn'),'Slim', |
if(match([knockers], 'urn'),'Standard',
if(match([knockers], 'urn_with_spyhole'),'Standard (V)',
if(match([knockers], 'slimline_urn_with_spyhole'),'Slim (V)',
if(match([knockers], 'ingot'),'Ingot',
if(match([knockers], 'horsetail'),'Horsetail',
if(match([knockers], 'no_knocker','None'),'None')))))))
Sussed it myself people
[handles], | |
if([knockers] = 'slimline_urn','Slim', |
if([knockers] = 'urn','Standard',
if([knockers] = 'urn_with_spyhole','Standard (V)',
if([knockers] = 'slimline_urn_with_spyhole','Slim (V)',
if([knockers] = 'ingot','Ingot',
if([knockers] = 'horsetail','Horsetail',
if([knockers] = 'no_knocker','None','None'))))))) as [knockers],
[letterplates], |
Cheers, just uploaded another way that works too