HannahS - profile

HannahS · Feb 26, 2025

I am struggling with the last stage of an automation and keep getting a message that it's received invalid inputs but I can't figure out what I'm doing wrong. I'm a Literary Agent and have a Titles table, an Authors table and an Editors Table.When I'...

HannahS · Feb 25, 2025

Hi,I'm trying to create a table to track income and the records feed from different tables using automations which are assigned a deal type as they're created. If they're type A the commission is 15% of the payment amount, if they're type B the commi...

HannahS · Dec 06, 2024

I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so t...

HannahS · Oct 23, 2024

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...

HannahS · Oct 02, 2024

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)...

HannahS · Feb 28, 2025

Thanks for this...So my first stage seems to be okThen it manages to find the relevant record successfullyBut then when I run the update to the base record with the record ID I get this

HannahS · Feb 27, 2025

Thanks for this - I'm definitely interested in learning about how junction tables work so will take you up on the offer of talking it through.

HannahS · Feb 27, 2025

Hi, I'm definitely using the record ID from the search, but how do I check if the field expects an array format and that the automation has the right permissions?Thanks

HannahS · Feb 25, 2025

Although, now you've said that, I've gone back to the formula with the extraction and added 0 there and now I don't need do do it in each individual calculation so thank you for prompting me to think about that!

HannahS · Feb 25, 2025

Thanks, but I can't see a way to do that - because these records are created by automation from a couple of different tables and I need the record names to be fairly descriptive (so 'Payment stage' 'project' 'amount') and then I extract the amount fr...

User Statistics

User Activity

Automation to create Link to an existing table

switch or nested IF for conditional commission calculation

Date Selection from three options

Automations to create new records in a new table

Auto fill attachment for every new record?

Re: Automation to create Link to an existing table

Re: Automation to create Link to an existing table

Re: Automation to create Link to an existing table

Re: switch or nested IF for conditional commission calculation

Re: switch or nested IF for conditional commission calculation