# \#data-sanctity **URL:** https://forums.knack.com/tag/data-sanctity/214.md [Latest](https://forums.knack.com/latest.md) · [Categories](https://forums.knack.com/categories.md) · [Tags](https://forums.knack.com/tags.md) --- ## ['Old' and 'new' field value for Record Rule](https://forums.knack.com/t/old-and-new-field-value-for-record-rule/12278)
**Author:** [@KnackPros](https://forums.knack.com/u/KnackPros)\ **Replies:** 4\ **Last updated:** [January 7, 2024, 11:08pm UTC](https://forums.knack.com/t/old-and-new-field-value-for-record-rule/12278 "2024-01-07T23:08:53Z")
As a Builder, when creating a Record Rule on the form, I want the “old” and “new” field values, so I can track changes more easily. Background Knack has a feature for “has changed” in Record Rules. When “has changed” i… --- ## [Text combo field as a unique](https://forums.knack.com/t/text-combo-field-as-a-unique/9515)
**Author:** [@Asokan80718](https://forums.knack.com/u/Asokan80718)\ **Replies:** 13\ **Last updated:** [October 9, 2022, 8:45am UTC](https://forums.knack.com/t/text-combo-field-as-a-unique/9515 "2022-10-09T08:45:46Z")
Text combo field does not accept unique nature. This will give different combo to filter in the related records --- ## [New Builder: Add a Field Reference Inspector function](https://forums.knack.com/t/new-builder-add-a-field-reference-inspector-function/8895)
**Author:** [@AlagoLowe](https://forums.knack.com/u/AlagoLowe)\ **Replies:** 0\ **Last updated:** [September 26, 2020, 4:00am UTC](https://forums.knack.com/t/new-builder-add-a-field-reference-inspector-function/8895 "2020-09-26T04:00:00Z")
Often there is a need to find out if a field is used by which other fields or is referred in which views. It would be very helpful to add a function (the field menu is a good location to add) to inspect the reference of… --- ## ['Before' and 'after' option for emails sent on form submission when a field changes (especially connected fields)](https://forums.knack.com/t/before-and-after-option-for-emails-sent-on-form-submission-when-a-field-changes-especially-connected-fields/6029)
**Author:** [@GraemeWill18377](https://forums.knack.com/u/GraemeWill18377)\ **Replies:** 0\ **Last updated:** [October 5, 2016, 8:29am UTC](https://forums.knack.com/t/before-and-after-option-for-emails-sent-on-form-submission-when-a-field-changes-especially-connected-fields/6029 "2016-10-05T08:29:00Z")
There are a few different topics requesting the ability to send an email from a form submission when a specific field is changed. This is something I also want. This specific topic takes it further, as I would like to b… --- ## [Please add the ability to display calculations in Engineering or Scientific Notation](https://forums.knack.com/t/please-add-the-ability-to-display-calculations-in-engineering-or-scientific-notation/8923)
**Author:** [@SteveBalla15396](https://forums.knack.com/u/SteveBalla15396)\ **Replies:** 0\ **Last updated:** [May 11, 2020, 12:14pm UTC](https://forums.knack.com/t/please-add-the-ability-to-display-calculations-in-engineering-or-scientific-notation/8923 "2020-05-11T12:14:00Z")
Please add the ability to display calculations in Scientific and/or Engineering Notation. e.g. 0.0000197177 to have the option to be displayed as 1.97 x 10^-5 in scientific. If you were able, you could go as far as addi… --- ## [Report Charts & Tables show old data which is no longer there](https://forums.knack.com/t/report-charts-tables-show-old-data-which-is-no-longer-there/8916)
**Author:** [@SteveBalla15396](https://forums.knack.com/u/SteveBalla15396)\ **Replies:** 0\ **Last updated:** [May 17, 2020, 2:45pm UTC](https://forums.knack.com/t/report-charts-tables-show-old-data-which-is-no-longer-there/8916 "2020-05-17T14:45:00Z")
Despite refreshing and reloading data into the same object, data values which were previously within a record still appear as categories on tables and charts within the app view, like some sort of "ghost record". For tho… --- ## [Date field input data values](https://forums.knack.com/t/date-field-input-data-values/8900)
**Author:** [@RayWindlow56888](https://forums.knack.com/u/RayWindlow56888)\ **Replies:** 0\ **Last updated:** [August 2, 2020, 8:29pm UTC](https://forums.knack.com/t/date-field-input-data-values/8900 "2020-08-02T20:29:00Z")
Often have data provided digitally in variety of formats i.e 23 Jun 1995 Jun 23 1995 Because of date format being limited to a single nominated format mean we can't cut and past data into the field. Would like to se… --- ## [Require unique by connected field to the logged-in user](https://forums.knack.com/t/require-unique-by-connected-field-to-the-logged-in-user/8876)
**Author:** [@AdamWalter80064](https://forums.knack.com/u/AdamWalter80064)\ **Replies:** 0\ **Last updated:** [February 25, 2021, 9:39pm UTC](https://forums.knack.com/t/require-unique-by-connected-field-to-the-logged-in-user/8876 "2021-02-25T21:39:00Z")
Currently the platform allows a field to require unique values but this doesn't work when you have multiple users who enter rows into the same database, as they would be prevented from entering a code if another user use… --- ## [Unintuitive Rounding](https://forums.knack.com/t/unintuitive-rounding/6126)
**Author:** [@JeremyNels15348](https://forums.knack.com/u/JeremyNels15348)\ **Replies:** 0\ **Last updated:** [May 5, 2017, 10:11pm UTC](https://forums.knack.com/t/unintuitive-rounding/6126 "2017-05-05T22:11:00Z")
I just had a customer call with a billing mistake that helped me uncover what I would consider to be a bug in Knack. I suppose it's more like a design choice that I think should be reconsidered, as it leads to frustrate… --- ## [Exporting over 10,000 records at a time](https://forums.knack.com/t/exporting-over-10-000-records-at-a-time/8886)
**Author:** [@PabloDelaG04348](https://forums.knack.com/u/PabloDelaG04348)\ **Replies:** 1\ **Last updated:** [February 8, 2021, 7:25pm UTC](https://forums.knack.com/t/exporting-over-10-000-records-at-a-time/8886 "2021-02-08T19:25:24Z")
We've been using Knack for a little over a year for both our business and our customers, we are almost at the top tier plan and have found a major hurdle. We are not able to export over 10,000 or sometimes 15,000 record… --- ## [Stop converting Emails addresses to lowercase](https://forums.knack.com/t/stop-converting-emails-addresses-to-lowercase/8927)
**Author:** [@JulianKirkness](https://forums.knack.com/u/JulianKirkness)\ **Replies:** 1\ **Last updated:** [January 2, 2021, 10:12pm UTC](https://forums.knack.com/t/stop-converting-emails-addresses-to-lowercase/8927 "2021-01-02T22:12:29Z")
I have a client who is having trouble with some users who's email addresses are mixed case. Knack converts these email addresses to all lower case on entry and this causes any emails sent to those users to be lost. Can … --- ## [Treating NULL and zero differently in validation rules](https://forums.knack.com/t/treating-null-and-zero-differently-in-validation-rules/8931)
**Author:** [@InaKinski73944](https://forums.knack.com/u/InaKinski73944)\ **Replies:** 2\ **Last updated:** [February 19, 2020, 3:42am UTC](https://forums.knack.com/t/treating-null-and-zero-differently-in-validation-rules/8931 "2020-02-19T03:42:02Z")
In my application, users are entering a coordinate in a fancy "corrected for all sorts of stuff format". Any map people, you know what I mean! The entries are not required for the form. The entries must be of certain c… --- ## [Text in numeric fields](https://forums.knack.com/t/text-in-numeric-fields/6038)
**Author:** [@BethC97369](https://forums.knack.com/u/BethC97369)\ **Replies:** 2\ **Last updated:** [October 26, 2019, 3:28pm UTC](https://forums.knack.com/t/text-in-numeric-fields/6038 "2019-10-26T15:28:54Z")
Currently, forms allow text to be entered into numeric fields. Although the text will not be stored in the numeric field (it will store a 0), text should not be allowed to be entered into the form. There should be an e… --- ## [Time stamp on exports](https://forums.knack.com/t/time-stamp-on-exports/9277)
**Author:** [@WilliamTho78175](https://forums.knack.com/u/WilliamTho78175)\ **Replies:** 1\ **Last updated:** [August 18, 2019, 6:29pm UTC](https://forums.knack.com/t/time-stamp-on-exports/9277 "2019-08-18T18:29:40Z")
I need to export my payroll table to my payroll processor bi-monthly. It is vital that I know exactly when the payroll export happens because it captures all the latest employee logged sessions by the minute. It would… --- ## [Timezone included on date/time fields](https://forums.knack.com/t/timezone-included-on-date-time-fields/6296)
**Author:** [@JamesAuger11978](https://forums.knack.com/u/JamesAuger11978)\ **Replies:** 4\ **Last updated:** [July 8, 2018, 9:04pm UTC](https://forums.knack.com/t/timezone-included-on-date-time-fields/6296 "2018-07-08T21:04:10Z")
As a Builder, I would like a timezone to be included with a date / time field so that I can clearly see our identified pickup & delivery times. For example, Pickup date is 7/20/2018 at 14:00 ET, Delivery date is 7/24/201… --- ## [Lock record on edit entry](https://forums.knack.com/t/lock-record-on-edit-entry/5674)
**Author:** [@andrewstee38626](https://forums.knack.com/u/andrewstee38626)\ **Replies:** 1\ **Last updated:** [May 10, 2017, 10:56pm UTC](https://forums.knack.com/t/lock-record-on-edit-entry/5674 "2017-05-10T22:56:59Z")
We need to be able to lock a record as soon as it is in edit mode ... currently 2 people working on the same 'work to' list can access the same record and potentially edit/work on it at the same time ... very dangerous .… --- ## [Scheduled cleanups](https://forums.knack.com/t/scheduled-cleanups/5915)
**Author:** [@AdamNograd37186](https://forums.knack.com/u/AdamNograd37186)\ **Replies:** 2\ **Last updated:** [March 27, 2016, 9:03pm UTC](https://forums.knack.com/t/scheduled-cleanups/5915 "2016-03-27T21:03:08Z")
I would like to request an addition to the "Jobs" feature, namely the ability to delete records. It's to support our database cleanup processes which are manual at the moment. We end up having lots of records created unn… --- ## [Compare fields](https://forums.knack.com/t/compare-fields/5878)
**Author:** [@KeithHickm79721](https://forums.knack.com/u/KeithHickm79721)\ **Replies:** 1\ **Last updated:** [January 13, 2016, 3:12pm UTC](https://forums.knack.com/t/compare-fields/5878 "2016-01-13T15:12:39Z")
I'd like to request the ability to compare fields within an object and between connected objects. For instance, I've got a "need-by" date field in my orders object and an "acknowledged" date field in the same object (v… --- ## [Formatting option of autoincrement fields](https://forums.knack.com/t/formatting-option-of-autoincrement-fields/5535)
**Author:** [@StevanLECO51061](https://forums.knack.com/u/StevanLECO51061)\ **Replies:** 4\ **Last updated:** [March 19, 2015, 11:47pm UTC](https://forums.knack.com/t/formatting-option-of-autoincrement-fields/5535 "2015-03-19T23:47:57Z")
offer the possibility to choose a number of digits so autoincrement 1 could be displayed with a number of zeros, ie, - 2 digits : "1" is displayed "01" - 3 digits : "1" is displayed "001" etc. It would offer a better v… --- ## [Submit rules for login forms](https://forums.knack.com/t/submit-rules-for-login-forms/5509)
**Author:** [@BobLove38845](https://forums.knack.com/u/BobLove38845)\ **Replies:** 1\ **Last updated:** [January 14, 2015, 6:17pm UTC](https://forums.knack.com/t/submit-rules-for-login-forms/5509 "2015-01-14T18:17:11Z")
Would like to have an option to email when someone logs in (submit) along with their user name. Or, post to a data object for a log of who is logged in and the last time they logged in.