# Advanced Function Fields

**URL:** <https://forums.knack.com/t/advanced-function-fields/10382>\
**Category:** Feature Requests\
**Tags:** equation-field, calendars\
**Created:** [February 18, 2015, 7:13pm UTC](https://forums.knack.com/t/advanced-function-fields/10382 "2015-02-18T19:13:00Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brandon](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/brandon/32/255_2.png) [@Brandon](https://forums.knack.com/u/Brandon)\
**Post date:** [February 18, 2015, 7:13pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/1 "2015-02-18T19:13:00Z")

</div>

We're considering adding specialized field types for advanced functions and calculations. Things like "Square Root" for number fields and "Day of Month" for date fields.

We'd love any suggestions for function types and how you'd like to use them.

---

<div class="post-metadata">

**Author:** ![KeithSterl25609](https://avatars.discourse-cdn.com/v4/letter/k/ee59a6/32.png) [@KeithSterl25609](https://forums.knack.com/u/KeithSterl25609)\
**Post date:** [November 7, 2015, 11:56am UTC](https://forums.knack.com/t/advanced-function-fields/10382/2 "2015-11-07T11:56:40Z")

</div>

1. square root (better yet _n_ root)
2. some kind of conditional&nbsp;_if...then...else_&nbsp;function
3. round
4. sine, cosine, tangent
5. absolute value (although this can be done with square root if you had that)

---

<div class="post-metadata">

**Author:** ![TimvanGeld30783](https://avatars.discourse-cdn.com/v4/letter/t/9d8465/32.png) [@TimvanGeld30783](https://forums.knack.com/u/TimvanGeld30783)\
**Post date:** [October 19, 2015, 5:14am UTC](https://forums.knack.com/t/advanced-function-fields/10382/3 "2015-10-19T05:14:01Z")

</div>

square root would be simply dandy

I want to calculate a confidence interval - a pretty basic statistical property. &nbsp;Need sqrt - trying to implement square rooting using the limited functions currently available seems, if not impossible, at least a nightmare

---

<div class="post-metadata">

**Author:** ![Jason41962](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jason41962/32/22_2.png) [@Jason41962](https://forums.knack.com/u/Jason41962)\
**Post date:** [October 16, 2015, 8:51pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/4 "2015-10-16T20:51:43Z")

</div>

I would love to be able to extract certain data from any field that is grouped such as Address field, &nbsp;i need to display the City, ST only from that field but cannot separate it out. &nbsp; This could work similar to the text combo field no? &nbsp; Maybe with some find/replace matching to separate out the content needed? &nbsp;or in my case just the ability to display parts of multi-data fields like the Address field.

---

<div class="post-metadata">

**Author:** ![nicholasmi75988](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@nicholasmi75988](https://forums.knack.com/u/nicholasmi75988)\
**Post date:** [October 14, 2015, 1:41pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/5 "2015-10-14T13:41:24Z")

</div>

Any chance to use the sum fields for calculations?

---

<div class="post-metadata">

**Author:** ![MarkCrawfo95602](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/markcrawfo95602/32/170_2.png) [@MarkCrawfo95602](https://forums.knack.com/u/MarkCrawfo95602)\
**Post date:** [July 3, 2015, 10:46pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/6 "2015-07-03T22:46:34Z")

</div>

For the date field it would be great to have the following options

Date&nbsp;

- is before
- is before or equal to
- is after
- is after or equal to
- is equal to
- is not equal to
- is blank
- is not blank

The next set of options after the above is chosen would be

- The Date
- This many days ago
- This many days from now
- Yesterday
- Today
- Tomorrow
- This week
- Last week
- Next week
- This month
- Last month
- Next month
- This quarter
- Last quarter
- Next quarter
- Last year
- This year
- Next year

  

This would enable you to check a due date that before 30 days in the past and only display those records. With the current date filters I am unable to figure out how to do that.&nbsp;

---

<div class="post-metadata">

**Author:** ![AlistairOa53791](https://avatars.discourse-cdn.com/v4/letter/a/b5e925/32.png) [@AlistairOa53791](https://forums.knack.com/u/AlistairOa53791)\
**Post date:** [June 30, 2015, 11:56am UTC](https://forums.knack.com/t/advanced-function-fields/10382/7 "2015-06-30T11:56:41Z")

</div>

Added to the above - it would be great to have additional Date field filter options.&nbsp;

As well as the below, it would be VERY useful to have the "is not" versions of the following:

Is not today (obvi. you can use the is not XX/XX/XXXX but this doesn't update for preset filters)Is not during the current (week, month, quarter, year)Is not during the previous (day, week....)

---

<div class="post-metadata">

**Author:** ![KenMaynard80754](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kenmaynard80754/32/137_2.png) [@KenMaynard80754](https://forums.knack.com/u/KenMaynard80754)\
**Post date:** [June 25, 2015, 7:25pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/8 "2015-06-25T19:25:58Z")

</div>

Days between dates

Year of date

Month of Date

Day of Date

Day of Week of Date

A suite of String Functions

---

<div class="post-metadata">

**Author:** ![nicholasmi75988](https://avatars.discourse-cdn.com/v4/letter/n/ce7236/32.png) [@nicholasmi75988](https://forums.knack.com/u/nicholasmi75988)\
**Post date:** [June 25, 2015, 6:40am UTC](https://forums.knack.com/t/advanced-function-fields/10382/9 "2015-06-25T06:40:27Z")

</div>

I would like the suggestion of end &nbsp;of month + () number of days&nbsp;

---

<div class="post-metadata">

**Author:** ![JakeTropf98059](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@JakeTropf98059](https://forums.knack.com/u/JakeTropf98059)\
**Post date:** [June 23, 2015, 12:01am UTC](https://forums.knack.com/t/advanced-function-fields/10382/10 "2015-06-23T00:01:24Z")

</div>

I would love to see adding colored backgrounds to object fields when forms are submitted. Example:

Record Rules:

Action\>update this record

When\>every form submission

Values\>Set\>\_\_\_\_\_\_\_\_\_\_\_\>to color\>\_\_\_\_\_\_\_\_\_\_\_.

---

<div class="post-metadata">

**Author:** ![PatrickHot45498](https://avatars.discourse-cdn.com/v4/letter/p/22d042/32.png) [@PatrickHot45498](https://forums.knack.com/u/PatrickHot45498)\
**Post date:** [June 12, 2015, 7:25pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/11 "2015-06-12T19:25:13Z")

</div>

I would work on improving your Sum function, so that when the Sum changes fields that reference the Sum will also change.

---

<div class="post-metadata">

**Author:** ![ShawnBeagl08562](https://avatars.discourse-cdn.com/v4/letter/s/5f9b8f/32.png) [@ShawnBeagl08562](https://forums.knack.com/u/ShawnBeagl08562)\
**Post date:** [June 8, 2015, 12:10am UTC](https://forums.knack.com/t/advanced-function-fields/10382/12 "2015-06-08T00:10:03Z")

</div>

I'm new to Knack, but I'd like to set EOM (end of month), and custom recurring days (ie recur in 7 days, or recur in 20 days, 30 days, etc). &nbsp;This is useful for a great many apps in my business. &nbsp;

---

<div class="post-metadata">

**Author:** ![MarcBonita75552](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@MarcBonita75552](https://forums.knack.com/u/MarcBonita75552)\
**Post date:** [June 4, 2015, 8:01pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/13 "2015-06-04T20:01:18Z")

</div>

Adding "Day of Week" (Monday, MON or MO) to date fields would be useful. We schedule weekly tasks, would be nice to sort/view by day of the week.

---

<div class="post-metadata">

**Author:** ![TimvanGeld30783](https://avatars.discourse-cdn.com/v4/letter/t/9d8465/32.png) [@TimvanGeld30783](https://forums.knack.com/u/TimvanGeld30783)\
**Post date:** [April 21, 2015, 12:19am UTC](https://forums.knack.com/t/advanced-function-fields/10382/14 "2015-04-21T00:19:24Z")

</div>

log(number, [base])

---

<div class="post-metadata">

**Author:** ![DustinHoll78663](https://avatars.discourse-cdn.com/v4/letter/d/f0a364/32.png) [@DustinHoll78663](https://forums.knack.com/u/DustinHoll78663)\
**Post date:** [April 10, 2015, 6:32pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/15 "2015-04-10T18:32:04Z")

</div>

I would love to see some date functions work across child records. &nbsp;For instance you may have project record that has Milestones in it with a date (or preferably a date range) and those limits could be applied to a date range in the Project that can grow and change as Milestones are added, edited or deleted. &nbsp;A cascade would be the best option so the Tasks below a Milestone could then cascade up to change the date field in the Milestone and so on up to the Project.

---

<div class="post-metadata">

**Author:** ![PatrickHef54525](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@PatrickHef54525](https://forums.knack.com/u/PatrickHef54525)\
**Post date:** [April 2, 2015, 2:28pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/16 "2015-04-02T14:28:56Z")

</div>

I thought I just did this, but may have inadvertently just sent and email to Louis Springer whose comment (just above) prompted mine. Apologies to Louis, if so . .&nbsp; 🙂

Because I use Knack for historical records I would like to have this format:

DD Month name YYYY

Note: no punctuation between the three values, just a space. Thanks.

---

<div class="post-metadata">

**Author:** ![PatrickHef54525](https://avatars.discourse-cdn.com/v4/letter/p/f0a364/32.png) [@PatrickHef54525](https://forums.knack.com/u/PatrickHef54525)\
**Post date:** [April 2, 2015, 2:17pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/17 "2015-04-02T14:17:20Z")

</div>

Because I use Knack for historical records, I would also very much like to have the format:  
DD Month name YYYY  
Note: no punctuation between the three values, just a single space. Thanks.

&nbsp;

---

<div class="post-metadata">

**Author:** ![LouisSprin93085](https://avatars.discourse-cdn.com/v4/letter/l/76d3ee/32.png) [@LouisSprin93085](https://forums.knack.com/u/LouisSprin93085)\
**Post date:** [April 2, 2015, 1:40pm UTC](https://forums.knack.com/t/advanced-function-fields/10382/18 "2015-04-02T13:40:52Z")

</div>

New dates formats:

\*DD/MM

\*MM/DD

\*MM/YY

\*DD, month name, YY

Caculations with date formats:

\*Sum just days

\*Sum just months but fix days&nbsp;

\*Sum just months but fix days and fix years

\*Sum just Years

&nbsp;

---

<div class="post-metadata">

**Author:** ![JonEvans85068](https://avatars.discourse-cdn.com/v4/letter/j/ecccb3/32.png) [@JonEvans85068](https://forums.knack.com/u/JonEvans85068)\
**Post date:** [March 27, 2015, 12:04am UTC](https://forums.knack.com/t/advanced-function-fields/10382/19 "2015-03-27T00:04:22Z")

</div>

MUST HAVE A PAYMENT CALCULATION FORMULA!!!&nbsp; i.e.  
(r\*PV)/(1-(1+r)^-n  
  
Currently you can’t “raise to a power” with the “^” key in a formula field so it’s tough to calculate payment amounts.

&nbsp;

---

<div class="post-metadata">

**Author:** ![JonEvans85068](https://avatars.discourse-cdn.com/v4/letter/j/ecccb3/32.png) [@JonEvans85068](https://forums.knack.com/u/JonEvans85068)\
**Post date:** [March 23, 2015, 6:14am UTC](https://forums.knack.com/t/advanced-function-fields/10382/20 "2015-03-23T06:14:44Z")

</div>

I would really like to see a “Year” function that displays just the year from a full date, or even the option to do this in the “Date Formula” field type.  
  
I also love ALL the other ideas so far!

&nbsp;

[Next page](https://forums.knack.com/t/advanced-function-fields/10382.md?page=2)
