-
Beginner's question
This is so simple and basic I'm almost embarrassed to ask. I have a recipe database one of whose fields is 'Ethnicity', with various options (Chinese, Italian, Greek, etc.).…
- Answered
-
unknown base type undefined
I have just created a HUD toggle on/off field pair, yes/no toggle with formula to hide icons. I have created a load of them so know what to do. But this error is popping up for a new one I have…
- 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
-
Need a Constrain
Sorry to bother Fred, I need the constrain for WBS level 5, and. I sent you a mochet. Thanks
- Answered
-
Setting a color for a TAB - Ninext
@Jacques TUR I have this on a TAB in Display if: which works perfectly, function onUpdate(event : any) do { caption: "LOCATION NOTES", color: "#fcfcfc", backgroundColor: "#ff3333", tooltip:…
- Answered
-
Filter an array based on a Multichoice using another Multichoice
So I was wondering how to filter an array that will keep NId and then compare a basic multichoice with another basic multichoice. If you open the attached DB,…
- Answered
-
Change the Choice Value or reorder again
There are any way to reorder the Choice number to 1,2,3,4,5,6,7
- Answered
-
Creation Date
Hello everyone, I wanted to add a date field in my database, in order to have the creation date of each record. I was wondering if this date already exists within the records and if it does,…
- Answered
-
popupRecord for child record via button
Dear Support-Community I'm new at using Ninox and I try to figure out some things. I want tho give the user the possibility to go directly to a child record with a button.…
- Answered
-
Use Tooltip to echo contents of a field.
Probably for the JS/HTML/CSS geniuses @Jacques TUR :-). I have formula field which fetches a note field contents from another table. Because I have to keep the formula field as small as possible the…
- Answered
-
Sum of fields for a period of time
I have a table "credit_Fill" and the second table "Tables". In the Credit table there is a credit field, in which credits are recorded that are related to a particular table.…
- Answered
-
There must be a better way...
I have the following code: let curRider := 'Team Membership'.RiderID; let rndJmp := RiderResults.'Round Type'; let x := for loop1 in rndJmp do AllResultRecIDs[RiderID !…
- Answered
-
Remove the repeated values from CutOff
Hi all again Starting from CutOff Date I need to remove the repeated values, In the picture the case, as CutOff Date 31/March/2023, eliminate the values of Real and Cumulative Cost down from…
- Answered
-
Formula Problem
let myFrom := 'From Date'; let myTo := 'To Date'; select Documentos where FechaR1 <= myFrom or FechaR1 >= myTo and 'Horas Ganadas Real' = 0 I try to use these Formula but not working I need the…
- Answered
-
Sort json?
Hi everyone - I'm trying to create an HTML table but want to be able to sort it, probably by using a choice field that would modify the order. I can't just sort the select because one of the fields…
- Answered
-
Automatically change a select field based on a date from another field
Hello, I allow myself to seek the help of the community to know if it is possible to modify a field after a defined time. I use Ninox as a CRM (customer management) I have a subtable for activities…
- Answered
-
shareLink Problem
1. I create a text field (ShareField) 2. I create a button with this code. for i in select Albums do i.(ShareLink := shareFile(Cover)) end Copy 3. I try to show the Cover here.…
- Answered
-
Filter Choice (Dynamic)
@RoSoft_Steven @Fred Hi I have the table with 5 field Choice Dynamic each for one Level of the WBS. All 5 field are Choice Dynamic , each deliverable an Budget is associated with your Level I need…
- Answered
-
Yes/No function
Hi, I want to change my multiple choice function to several yes/no functions. All works well but one choice. I want to use a yes/no function (named OHW) to indicate that a client is no longer an…
- Answered
-
Table cels Background color
Good morning, I would like to create a rule so that the background is green when the indication is 'NO' and green when the indication is 'YES'. I saw that NINOX provides this for sub-tables,…
- Answered
-
Avoid spaces in a sum function when a variable is empty/void
Hello, the product name in my products database is a sum of 9 text and number fields, like this article + " " + Color + " " + more stuffs + " " +kg + " " lt" it works for normal use but in print view,…
- Answered
-
Conditional Formating for Dates
Hi, I need to create a Conditional Formating for Column FechaP1 to compare with other field DataDate that field is unique only one date. => Value Color The conditional not available for Dates
- Answered
-
Unique / Concat giving different results
Hi all. I have a table showing Orders, in which I have Items that are linked to Products, which each have their own Product Categories (in a multiple choice field).…
- Answered
-
Display multiple dynamic choice items separated by returns rather than commas in Print
I have a table with a dynamic multiple choice field. I am trying print a record with the contents of the dynamic choice field displayed on separate lines.…
- Answered
Answer questions and share your knowledge