-
How do you give a Yes/No field in Chart text names instead of 1/No
I've created a Chart where there is a Yes/No field called PAID where I want to show the Data separated depending on if it is a Yes or a No. However on the Chart is shows up as a 1 or the work No so…
- Answered
-
Problem N:1 Activity_Name
@ Fred On Staff Hour table, I create Activity_Name (N:1 'Staff Hours' To Activitires) for select the Activity. With the Add Register button add the info to ' History Hours' but no find the way to…
- Answered
-
Compare fields of 2 tables to get result
Hi, I have a "Carte-cadeaux" table in which I have the following fields: - "Code de la carte-cadeau" in text format - "Solde restant" in number format From another table named "Paiements" I have a…
- Answered
-
Button to Send Message and Create Entry in Log
Hi, can someone help please. I'm almost there. I have this Tab So when I click on 'Join Reminder' button it creates a Text message for sending and this works perfectly.…
- Answered
-
Double action button
Hello everyone, I've created a data base witch manage software licence subcriptions. I've added one button that allows to renew the licence. I want that button to add one year to the end date…
- Answered
-
Warning / alert triangle on Table name
Hi - I have just noticed that a couple of Tables have small warning triangle symbols over their names / icons in Edit mode. As far as I can see, there are no functional problems.…
- Answered
-
What does it mean and what does it do ?
not (ninoxApp() like "android" or ninoxApp() like "iphone") on Display field only if
- Answered
-
Next Item in Line Formula
I am creating an approval flow in Ninox. I have a field named 'Current Step' and a list of that displays the order of the steps. Named 'Step Order' and the value is '1,2,…
- Answered
-
Records filtered by Dynamic Multiple Choice
So, I have many fields that are dynamic "single" choice. My goal is to filter data using a multiple choice dynamic field but am having issues with scripting it correctly.…
- Answered
-
Field txt to date(dd/mm/yyyy)
There are any script to convert a field txt to a date format (dd/mm/yyyy)
- Answered
-
Regarding the batch write issue.
I created a button to change existing data, but when I click the button, the returned data is always the same. I have tried this many times, but I can't find a solution. I am asking for your help.…
- Answered
-
About code Questions
上面的代码出现了问题,数据变得一样了。 “物流码” HTTPS://M.LZLJ.COM/R/122169506032380086 HTTPS://M.LZLJ.COM/R/122119277562447981 HTTPS://M.LZLJ.COM/R/122121718875948831 HTTPS://M.LZLJ.COM/R /122179735097552622 HTTPS://M.…
- Answered
-
field not found - Error
Hi! where is the error? let a := Testo if a = null then let b := "zero" else let b := "molti" end; alert(b) Field not found in line 7 Thanks!
- Answered
-
Problem with this formula
sum((select Expenses).'Amount Spent' where Categories = "Gas") sum((select Expenses).'Amount Spent' where text(Categories) = 8) Where Categories is a Choice field.
- Answered
-
Block of Time on Calendar
I am looking to create a block of dates on the calendar. I have a start date and finish date and i also want the days in-between to be used for the same project. Is this possible
- Answered
-
Combining two dates fields into single appointment field
Today I have Start and End date fields and I'd like to leverage the appointment field so I need to write a script that will combine them. However the format to do for the appointment field hasn't…
- Answered
-
Returning files that have a certain name
Hi! I have files attached to a record. concat(files(this)) returns all attached file names. I’m looking for a function that only returns files that start with the string "ABC" Can you help me, please?…
- Answered
-
Getting number from table
Hello and thank you in advance My Database has tables called Unit Rentals 1 Unit Rentals 2 Unit Rentals 3 i can't extract the number from a table like you can using a substring in a field any advice…
- Answered
-
Running number issue
Hello everyone. I've setup running numbers for our stock, invoices etc. That does work as intended. However, if any previous record is deleted, the next number created will be a duplicate.…
- Answered
-
Script not working dilemma
This simple script does not work in a working DB but is 100% in a restore and I cannot figure out why. No fieldnames have been changed, removed etc. The script does not indicate anything is amiss.…
- Answered
-
Formula for button
There is a Table1 where information is entered and when the button is pressed, the information is written to another table - table2 Here is part of the formula Date := xCurrRec.…
- Answered
-
Zero negative result in Formula
Hi! I have two fields: Total Invoice Amount Paid I have a function that calculates the difference Total Invoice - Amount Paid If the result is 0 the formula gives me a result -0.00 €.…
- Answered
-
Error to send Email
let check := dialog(" Audits Report ", " Confirm the sending of this email...> ", ["Do Not Send", "Yes Send"]); if check = "Yes Send" then sendEmail({ from: userEmail(user()), to: "ruben.leal@vepica.…
- Answered
-
Single Dynamic field that populates other fields
I am replacing some fields that had quirky lookups with a single dynamic field. I have a JobDockets table (related to Customers) ie N:1 - Customers can have many Jobdockets In Jobdockets Table.…
- Answered
-
Count missing dates
Hey all! I'm back with ANOTHER question. Is it possible to use Ninox to count missing dates? For example: on a timesheet I may work August 1,2,3,4,5,7,8,10,11,12,13,14,19,20,22,23,24,25,26,27,…
- Answered
Answer questions and share your knowledge