-
adding many record references
Is there a way to update multiple references at one time when linking two tables? I have thousands of records and it would take too long to go through them one by one.
-
Weeknumber and date
Hi i need to calculate a date. I know the weeknumber and the day.. Monday in week 7. How do i find the date for monday week 7 ? Henrik
-
Is there a way to adjust the row height in any view?
Is there a way to adjust the row height in any view?
-
Create n records in a subtable at once
Hi NX community! I have a table "A" which contains several records. I'm trying to come up with some code to set a button that should update the table "B" with all of the records coming from "A".…
-
Consistency check formula
Morning all, I'd like to ask once again for your help. I would like to have a field that checks if field A is equal to the sum of fields B+C, keeping a tolerance of one cent of difference.…
-
Hiding a multiple choice field
Hello, I'd like to hide a Date field if a specific option "A" is selected in a multiple choice field. So if "A" is selected, or "A" and "B" are selected together (every scenario in which A is one of…
-
Join on non-key field to update records
2nd try. I can't figure this out, but I think it should be simple. ITEM Import Table: Item ID, Available quantity, Import Timestamp. Target Table: Item: Item ID (not Ninxo ID but parent system id.…
-
To colour with conditional style with the id ?
Hi, Is there a way to color sommes values in a column with the conditional style with the id ? Normally one use the same letters of some names to color them.…
-
Mehrere Fortlaufende Nummern erstellen.
Hallo Hat jemand eine Idee für einen Code für folgende Situation: Zahlenfeld --> Startnummer Zahlenfeld --> Anzahl Button--> fortlaufende Nummern erstellen Mehrzeiliges Textfeld --> Hier soll nach…
-
TRIGGER problem - Help please!
Hello, I would like to use a trigger to make 2 changes, but my code only seems to make one change and I can't figure out why...can anyone help please? Am I trying to do something that can't be done?…
-
Difference between the "Rebuild index" and "Reindex files" buttons?
Under the Options tab (beside the "Data model" tab) what is the difference between clicking the "Rebuild index" and"Reindex files" buttons? What exactly does each do?…
-
ERROR in NINOX APP: BEGIN TRANSATION failed: getdelta
Good morning, a lot of my employes using the database in the phone/tablet are having this error (in Italian): "La pagina su "file://" visualizza: Begin TRANSACTION failed:…
-
Newest android update not working Samsung A71 & A21
The newest update is not working. We get error after error and can't even open the database. We tried different teams, different databases and even different android phones.…
-
Recover a field ?
Hi I have 2 tables in a database. I would like to recover an erased field from one of this table to the other. Can someone tell me the way to do it ? Thank you
-
problems with view
Hello all. I got great help with a problem with vaccinations this week, and now i have an other problem I have a table with traning activities for horses..…
-
Math symbol missing in a formula ?
Hi I try to select names wich are displayed only one time. So I use a formula for duplicates like this one : let myV := 'Bird name'; if cnt(select 'table name' where 'Bird name' = myV) > 1 then…
-
DYNAMIC MULTIPLE CHOICE appears in print layout
Hi everyone, how can I get appear the selections of a dynamic multiple choice in a print layout ? Thanks in advance
-
Update Field to Show Item Balance from Import
I would appreciate coaching on this update, as I can't seem to make it work. Each planning period I get a csv file that has ITEM ID and ITEM Available Quantity.…
-
To remove a lot of records
Hi, I have a lot of records to remove from a table. First one : ID 3825 Last one : ID 4249 I think there is a "delete" formula but I don't know how to manage it.…
-
Is there a way to refresh the screen to update a html progress bar in a for loop?
My code is as follows: let ofxSelected := (select OFXEntries);let countOFXSelected := 0;let countOFXAlreadyPosted := 0;for selectedOFX in ofxSelected do ProgressValue:…
-
Formula doesn't work until I populate each field in the formula at least one time, then works for the one record. Needs to be repeated in each record?
I have a strange situation. I have 3 phone fields, Phone, Phone 2, Phone 3. I have a formula to then display the phone number somewhere else in the record (in the same table).…
-
Full screen
Hi, How can i open a form in full screen! tx Regards Michel
-
Counting the number of
Good afternoon; I'm trying to learn how to count the number of entries with a particular status set. 1. I have two tables: JOBS and TASKS. 2. Each entry in JOBS can have multiple TASKS assigned to it,…
-
How to get Multiple Choice selections to appear on Print
I've looked at some example and still struggling to figure this out and basically I am using an "Invoice" like form and I have to instructions that need to be printed depending on if they are…
-
Copy record data from a table and create a record in other table
I need your help in creating a code for a button that allows me to copy and paste the data of a record from one table to another.I have a table 'ORDERS A' and a table with 'ORDERS B'.…