-
ID of a newly (Create 'table name')
How can I extract the ID of the new record created by: let i := (create 'table name');
- Answered
-
Merging RTF Fields
Is there a way to merge RTF text fields into another RTF text field and maintain formatting? When I merge RTF fields I get one large text paragraph with all CR's removed.
- Answered
-
extractx problem
no experience with regex Need to use extractx If anyone can help, would be greatly appreciated! text field = textA - textB would like to put textA into one field and textB into another field…
- Answered
-
Character Occurrences Count
Hello, I'm wondering if there's a way to count how many times a given character is in a string. i.e.: I have the field 'mytext' which contains a string (let's say "rockandrollwillneverdie") and I…
- Answered
-
Are there Trigger limitations?
I have a DCF (DMCF?) where a "Trigger after update" has the code: 'V.Välj Region' := ""; 'V.Välj Distrikt' := ""; 'V.Land' := text('V.Välj Land') it does't work BUT if I have the code: 'V.…
- Answered
-
Using an iFrame in Ninox to view a website
Can someone help with a sample script to add a website into a formula using iframe?
- Answered
-
Formula for Chart Line
I need a Chart Curve for the two columns %Plan vs %Real in the Form view How can I do that.
- Answered
-
Integromat "Webhook" Module: Bring the Ninox ID Record
Hi! How can I include the Ninox ID Record as a parameter in a URL (Integromat "Webhook" Module) embeded into an email done in Ninox? I mean: In Ninox I use sendEmail.…
- Answered
-
Search view Formula don't work
I Have these Formula for search Ganado Plan but don't work any idea. let Busqueda := Busqueda; select Documentos where 'Ganado PLAN' = " " = Busqueda
- Answered
-
Avoiding a circular reference
Here's a simplified version of a table I'm working on: closingBalance = openingBalance + Adding - Subtracting The problem I'm running into is that the openingBalance of the next month is supposed to…
- Answered
-
Finding the sum of the last entry given specific text in a field
Sorry for the nonsensical title. I have a table called Bulk Inventory: In a formula in a different table, I want to find the sum of the 'Cumulative (Laa)' values for the final entry of a given month…
- 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
-
Paste Excel cell intor RTF field with simple HTML
Ninox does a beautiful work when pasting a cell range into an RTF field: it is stored as HTML tables for free! That's great for our purposes but... the HTML tables stored do have some rich…
- Answered
-
Linking one record to one record
hello everyone I am working on a medical project I have a table with patient information such as name, ID, DOB, etc. I have created two more tables with a questionnaire and a CT report.…
- Answered
-
Linking populated tables
I am trying to migrate an existing database from Filemaker. I have exported the records from filmmakers as a CSV document and then imported them into a new table in Ninox. So far so good.…
- Answered
-
What means these mensage.
Hi what these mensage means, these error simbol ? only apearse in design view, but all work good.
- Answered
-
All I want for Christmas!
Ninox Support (When you are monitoring this forum - Please pay attention to this Santa Wish List thread. This is what your user base are listing here because we need a few (err probably more that…
- Answered
-
Trigger after update record not triggered when linking/adding records to sub-table
I don't know if this is a bug or a feature, but the Trigger after update is only triggered when editing data in normal fields. Any change in a sub-table does not trigger the script.…
- Answered
-
Closing account
Hello, I've started a free trial, but that works only online and it's not what I'm looking for I'd like to cancel the account I have created. Instead, if I buy the version "on premise",…
- Answered
-
Formula don't give anything
These Formula don't give me anything, any idea. let x := (select Documentos where Semana = 9); if Week = (select Documentos).Semana then sum(x.'Horas Ganadas Plan') end Thanks
- Answered
-
Locking and protecting records in a table
Hi Guys I have say a contact table that stores information on an employee, as part of that table I have a link from which contains competencies from another table.…
- Answered
-
Design Table for WBS
Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.…
- Answered
-
Production: should storage tanks share a table or each have their own?
I need some advice regarding the basic logical layout/relationships of my database. I'm tracking production and inventory in a distillery. I have a table for distillations,…
- Answered
-
Spam with sendEmail
Hello I have a issue. I send email via ninox and the email goes in spam each time. Any idea how to fix the situation and get the email in mailbox ? here the code sendEmail({ from:…
- Answered
-
Editing records in embedded view
Hi, small question: is it possible to edit records (like line items in an invoice) in the embedded table you get from the table relation? Or do you always have to go into the other table to edit the…
- Answered
Answer questions and share your knowledge