Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Philip_Barber
7 - App Architect
7 - App Architect
since ‎Sep 21, 2017
‎Nov 29, 2022

User Statistics

  • 45 Posts
  • 1 Solutions
  • 5 Kudos given
  • 16 Kudos received

User Activity

Is this a case for an IF statement?

Mar 06, 2021
My database has run well for 3 months but now I need to change the discount structure. I have added a Column and called it Qtr and each record will be either 1,2,3,or 4 the idea being that the discount offered for that Qtr could be different. So far...

Changing discount at the end of three month period

Mar 05, 2021
I currently have the following formula running since January that I want to be active for all bookings up to up the end of Mar 2021. {Extrachildren} * MIN(({Weeks FM/Zoom}+{WeeksSR}), 10) * 5 For April until June I want this formula to be active {Ext...

Amend a Formula to cater for a discount

Dec 14, 2020
I currently have a formula that calculates the cost of a child attending a class over a number of weeks. Extrachildren*({Weeks FM}+{WeeksSR})*5 This works well until I was told if they book for 11 weeks then the 11th week is free (they never book for...

Simplifying and completing a formula

Dec 10, 2020
I have a formula that correctly shows the cost of having 1 child in a class. When the parent has 2 or more children the cost is £5 per extra child per week. They could be in either Weeks FM or WeeksSR. So far I have a column showing “extraChildren” /...

Extracting Numeric Value from Text

Dec 03, 2020
I have a lookup option (in Number of weeks) that has two different values. I want to be able to extract the numeric value from either of the text strings that is chosen and place that value in the AMOUNT column but I have no real idea as to how to do...
View more
Copyright © 2025 Khoros, LLC
Top