-
Read only table
I would like to make a table accept data, but once entered it can't be altered, Any ideas?
- Answered
-
How do i track payments and update the new balance due?
We sell each customer one item and most of them make payments on it till it is paid off. We take in a CSV for each job that gives the DB the full total.…
- Answered
-
Formula don't work but no errors
I have this Formula but don't work, the HITOS is a Multiple choice Dynamics with 5 Options. I Try with HITOS = number(5) but not work if FechaF5 <= DataDate and FechaF4 !…
- Answered
-
How do i get my numbers $ to format right?
I can not get my imported in number - totals to format to show right. I have changed the formatting to every setting in their and none work to fix it. This is how they come in from my CSV files.…
- Answered
-
Complex Select statement for View
Summary of what I need to do: I have a table called Actions within which I am trying to create a view of all actions which are compatible with the current action.…
- Answered
-
Neither of the two formulas work
I try these two formulas but not work some ideas. select 'DOCUMENTOS' let xFld1 := 'Avance Plan'; let xFld2 := 'Avance Real'; let i := (create AVANCES_PROY); i.('Avance Plan' := xFld1); i.…
- Answered
-
Filter on hidden columns
Hi, How do I get a view which is a subset of the main table which does not show the field to which the filter is applied. I have a table which lists photographic films which has a text field for…
- Answered
-
Conversion into Ninox of old relational data
How would I import data into Ninox from multiple tables of a relational database built in another platform and keep records related? I am able to get primary and foreign keys into the right records…
- Answered
-
Return to my Topic
@Fred @RoSoft_Steven Rooryck To Return the topic since it point that I need to have my DB at last 90% . Excuse the insistence but is very important and I can't resolve this.…
- Answered
-
How to query a table using a dynamic combo box value?
I have the code below, i want to return the email address where the the full name of the staff is the one assigned to the ticket. let i := 'Assigned To';…
- Answered
-
Formula for combine two Alerts Date's
Hi I need combine this two Alerts in the same Formula 1 - These Formula if FechaR5 < FechaR4 then alert("Fecha Real 5 no puede ser menor que Fecha Real 4") else "ok" end 2- And These For Holidays…
- Answered
-
Formula diferent result
@Fred Hi the Cantidad Doc in the Formula is not the same on Table and Form if Clase = "Actividad" then cnt(select DOCUMENTOS where 'LT_Tipo Documentos'.…
- Answered
-
Help with wedding base
I am starting this new chat as the other one got long and i now have made a sample database and have a lot of info to better understand what i am trying to do. Here is the info.…
- Answered
-
Dynamic Choice Field reference in a function
Hi all, I want to make a function out of a formula I often use in my Database. The function involves the following fields: FieldA: text FieldB: text FieldC: date FieldD: choice FieldE:…
- Answered
-
Search with Multiple Choice problem
@Fred I use these Formula and work but the problem is I have only 3 items in the table Tipo de Documento and need to use aleatory case number. I try one by one I'm lucky to find the case number,…
- Answered
-
I Made A Wrong Payment and Ask For Return My Money Back
I Made A Wrong Payment and Ask For Return My Money Back, I double buy licenses, please return my money back.
- Answered
-
Conceptual Problem.
Conceptual Doubt about the Disciplines and Activities Tables The Disciplines table has some specialties, example Civil has Foundations etc as a specialty and each specialty has different activities,…
- Answered
-
Include field content in Formula acting as a button.
A typical example would be a formula acting as a button when adding contacts where the persons name is added so that a formula/button would be: Add John Doe as a new contact.…
- Answered
-
How to select a row from a composition table to display in a superform
I am new to Ninox and am struggling a little with programmatically searching records - the equivalent of SQL-world Select statements) . I have many years of relational database experience in…
- Answered
-
How to update a field with a lookup value from another table?
In the image above, I have selected an employee from the Employee table via pop-up. Now, however, I want to populate the "emp_fk" field in the Tasks table with the Employee's "emp_pk" field from the…
- 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
-
HTML text format doesn't work in view print preview
I'm using the html() function in formulas to make selected text bold (SECURITY DEPOSIT), leaving text before and after at the default setting: ... Premises.…
- Answered
-
Ninox Not Syncing with iCloud
I downloaded the iCloud Ninox app, but it doesn't see the Ninox databases that are in my iCloud account. The only (apparently non-synching) way I can get the data on iPhone is to save an archive.…
- Answered
-
Formula Problem.
Hi I need That if Horas Ganadas Real is = 0 then Horas Actuales is = 0 too. The Horas Actuales is a Formula let t := this; sum((select 'Horas-Actuales')[Semana <= t.Semana].'Horas Actuales')
- Answered
-
Date of value specific changing
Hello ! I'm looking for how i can get the date of when a value is becoming negative. I'd tried this code : "if 'Value' <= 0 then today() end" but the function today() returns the date of the present…
- Answered
Answer questions and share your knowledge