-
Define start of fiscal year
I can use the function yearweek() to define the week number within the year, but that does not sync with my employer’s fiscal year, which begins on the first Monday of the new year.…
- Answered
-
Problems with Formula Don't give me anything.
I have a Choice field With DateR1, DateR2...... to R5 What I need, Find all documents by DateRx that al delayed with respect to the CutOff date and not have Earned Value.…
- Answered
-
Newbie Formula Question
I think this is quite basic, but I'm new to all this and still learning! I have a table of contacts and one of the fields is a choice field that lists about 50 or so electoral ridings and I have…
- Answered
-
Choice field: There can be only one!
Hi All, sorry for the daft title. I am trying to establish a rule in a sub-table where only one choice field in all the records can should as active, when that record is set to active all other…
- Answered
-
Script to confirm date-time availability
I'm an "intermediate" MacOS app user, with a database to track short-term house-rentals. I need a script to confirm availability or flag date-time conflicts as I enter new bookings.…
- Answered
-
Can I use a "sum" function to add up just the items found through a search?
[Bear with me, I'm still new at anything but the most basic ways to use Ninox.] Here's my case: I've got a simple db set up to catalog a comic book collection.…
- Answered
-
The Formula don't work. For Approval view
let me := this; if 'Rev 0' != null then 'Approved Rev.0' = 0 else if 'Rev 0' is not null then 'Approved Rev0' = 1 else 'Approving Signature' := "Signed by: " + " " + userFullName() + ";…
- Answered
-
Sub-Tables - Add existing record
Has something changed with the new version (3.7.6) with regards to sub-tables? When a table has a sub-table linked to it there are now two buttons on the sub-table to "Add existing record" and…
- Answered
-
Script for transfer record N:1
I had to create an additiona table with relation N:1. Table A Reference N:1 to Table B On Table A now I have records included and I need to Include them in the Tabke B, isthere any scripts to do that.…
- Answered
-
Update Reference field from Text Field
Hello everyone. Assume I have 2 tables. 1. Customers -- It includes a field named "Company Name" 2. Service Reports -- It includes a popup field named "Customer" where I can select the company name…
- Answered
-
Need Help to create a History Control Table
I need a Control Table, where every time the FechaR3, FechaR4 and FechaR5 are met in the Documents Table, they are copied to the Control Table with the Document Name, the Code and all 3 Dates.…
- Answered
-
Optimize Formula
switch Medicion do case 1: (select DOCUMENTOS where 'Ganado REAL' = 10) case 2: (select DOCUMENTOS where 'Ganado REAL' = 50) case 3: (select DOCUMENTOS where 'Ganado REAL' = 80) case 4:…
- Answered
-
Alert function - trigger after update - cloud version
Hello, i would like an alert after trigger after update. On ipad/iphone this function works ok. On cloud version this doesnt work, when i use the same script with button everything works perfectly.
- Answered
-
Can't see records, while they can be searched and found...
This seems like a basic problem, but I am not to able to solve it. I have a database of wines I have in the cellar, and I retire them by the bottle. So when all bottles of a certain wine have been…
- Answered
-
Find weekends dates
Is there some code to detect weekends in a list of Dates. Now I have a list of 2500 dates records and I need to know which ones are weekends. Thanks
- Answered
-
Parent / Child / Grandchild
Hello there. I'm a new user and am struggling with the Parent / Child / Grandchild relationships. I have the set-up the following relationships as shown in the picture:…
- Answered
-
Carriage Return and Line Feed (CRLF)
Hi there, In Ninox, I want to create a text file for an import into a 3rd party solution. The 3rd party solution requires line breaks to be formatted as carriage return + line feed ("CRLF").…
- Answered
-
Filtering data based on manual dates entered.
Ok, another question here. I feel I am in the ball park. I am trying to sort my data based on when clients were terminated. However, those dates I want to use can always change based on what…
- Answered
-
Formula to Include Multiple Filters from Choice Fields
Ok, I have been stumbling a few days over this trying to get the right formula. What I am doing is creating a sub table to give me the values I need, so then I can draw those into a chart correctly.…
- Answered
-
Running total every 5 days
I want to sum expanse Sunday to Friday in work week expanse field and ignore Saturday to Sunday I can only sum per week by using week function can’t sum 5 days.
- Answered
-
Display value from unlinked table
Hello. I have a global Value (Exchange Rates) which I want to use in various other tables. So far I have a table called "Exchange Rates). There is a subtable for USD-THB exchange rate which will be…
- Answered
-
Problem in Calc_Dynamic
Hi I have two problems with this models. The Weeks field is Multiple Choice Dynamics can I groups by weeks ? In the example I have two hours on the same week 2.…
- Answered
-
need help with the replace function!!
I get an error on the replace line output2 := ""; let cr := "<br>"; let lr := " "; let myText := myRichText; output := myText; let cText := myText; let cText := replace(myText, cr, lr); let cText :…
- Answered
-
Copy text field to reference field
Hi Brain Trust, Is this possible? I would like to trigger after update a text field (copy a text field) to a reference field. They are both in the same table.…
- Answered
-
Search by Suppier from a Choice field
Here again Hi I import a large excel file with 23.652 Items. I try to search by Suppier from a Choice field but I haven't had any luck. Some help On the Search Tab do that with let search :…
- Answered
Answer questions and share your knowledge