I'm a literary agent and I'm trying to create a way to track my submissions of clients work to publishers. I have a client table, a titles table and an editor table. It's tricky to do this in any of these because some editors will see multiple projec...
I need my company logo to appear in every record in a table so that I can have it appear on the sales brochure I create in extensions (unless someone can explain how to do this using the static element there but I can't find a way to attach it there)...
Can anyone tell me where I'm going wrong with this formula? SWITCH( {HS-LA %},"15%", ({GBP Amount}-{HS-LA Commission}),"10%", ({GBP Amount}-{HS-LA Commission}-{HS-LA Commission}),)Or suggest another way to achieve it - I've tried a few IF options too...
I'm in the process of building my base for my business (I'm a literary agent) - I've recently discovered how useful views are and now have a much better sense of what I'm doing but I have a query and I'm wondering if there's a better way to set this ...
Ah, thank you, that's really useful. OK, I've now got the formula working so in the formula column I now get - title A - Editor 1, title A - Editor 4, title A - Editor 9 etc...but even with the duplicated base I can't figure out how to automate each ...
Ah, my question wasn't clear. So, in your example when the calculation runs you end up with 'Book 1 - Editor A' separately from 'Book 1 - Editor B' - all I've managed to achieve is 'Book 1 - Editor A, Editor B...' - I can't figure out how to write a ...
Oh, this looks exactly what I was trying to do! I hadn't thought to add the formula step in - that makes so much sense. I'll have a play and see if I can figure it out. Thank you
