CottageKeeper - profile

CottageKeeper · Jun 09, 2023

Trying to accomplish this simple formula but it results in an error???Using a Single Select Field and a Currency Field.{Toe Kick LI} * {Toe Kick Cost Per LI} Thanks in advanced for your assistance!

CottageKeeper · Feb 07, 2023

Need the 'Test Formula' field to format the 'Trip Total:' as currency. Any ideas anyone?

CottageKeeper · Feb 11, 2021

In the MP IMU% field I have this formula: IF({MP ICOGS},SUM({MP IGP} / {MP ICOGS})) My question is how do I change my formula to return a value in the MP IMU% field that is not a negative percentage? The true answer is 281.34% - I’m beyond stumped?...

CottageKeeper · Feb 11, 2021

I have expense fields set to ‘Allow Negative Numbers’. It would be really helpful to just enter 5.24 and have that field make it a negative number. I have a ton of fields I need to manually enter the currency for and trying to remember to add the m...

CottageKeeper · Feb 11, 2021

Is this even possible? I’ve watched a ton of automation tutorials and can’t find an answer. From the Transaction Type: Order >Item ID field I would like to add this ID # to the Transaction Type: Shipping label >Item ID And pretty much do the same th...

CottageKeeper · Mar 12, 2024

I clicked the link but the video only demonstrates adding one record. I am a visual learner is there a video that demonstrates a user filling it out and creating multiple records in one form? Maybe I have misunderstood - I need a single form that c...

CottageKeeper · Jun 12, 2023

Perfect! Thank you!

CottageKeeper · Feb 07, 2023

Many thanks to @W_Vann_Hall and his demonstration base for Pretty Print - for an answer!DATETIME_FORMAT({Date of Trip}, 'YYYY-MM-DD')&"\nTrip Total: "& IF(LEFT({Sourcing Trip Total}&'',1,1)='-','-','')&'$'&IF(ABS(VALUE({Sourcing Trip Total}&''))>=100...

CottageKeeper · Dec 14, 2021

ScottWorld: miniExtensions Form to Edit and Create Airtable Records It’s a shame Airtable wants me to spend $39 a month with another company so I can use a form to update existing data in my free Airtable. I love Airtable but their inability ...

CottageKeeper · Feb 11, 2021

@augmented Thank you! IF({MP ICOGS}, ABS({MP IGP}/{MP ICOGS})) This worked! COGS are actually expenses therefore they are entered as a negative number. All the income fields are entered as positive currency. Excel makes this easy but not so much ...

User Statistics

User Activity

Single Select Field and Currency Field Formula Results in Error

How to Format a Formula Field that pulls a Currency from another Formula Field

Calculating Markup Percentage is Returning a Negative Percentage

Automatically Convert a Number Entered in a Currency Field as a Negative Number

Update a blank record field from another record in the same table

Re: Is it possible to create a form that creates multiple records?

Re: Single Select Field and Currency Field Formula Results in Error

Re: How to Format a Formula Field that pulls a Currency from another Formula Field

Re: Form to edit data

Re: Calculating Markup Percentage is Returning a Negative Percentage