-
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
-
Determine Net New customers via Select Statement for Dashboard
I would like a formula field that will represent the number of clients we have in a month that are first time customers. We are an event company. This will be via a field on a dashboard I'm creating.…
-
Formula ID count also deleted records
Good morning everyone, I have a formula field with ID in it. This shows me the record number. My problem is that I have noticed that this formula also counts me the record ID's that have been deleted.…
- Answered
-
Formula turns into letter references
Hello, I am wondering if anyone else has experienced this. I am adjusting some of the structure of my app, and therefore have removed some fields and added new ones.…
-
Extract color or icon from styled field/var
I needed to extract the icon and colour from a styled value. The color() and icon() functions work for the choice field, but not for styled. When I looked up how to do this,…
-
Wrong ID in Multiple Choice?
I have a multiple choice field where I write a Note, and then assign it a Note Type. I'm trying to make a view where I can see what the Note is for ones that are "Issues".…
- Answered
-
Mail table
Hi, I would like to send a table via email. Is this possible! Regards Michel
-
Reverse Order by
Hi all - I was blown away by what a FB user posted in the Ninox English forum. I don't remember seeing this any where else. To do a reverse order by you can just put a "-" in front of the field name…
-
chatGPT - Ninox code
Just for laughs I asked chatGPT to give me some sample code for Ninox. This was offered: Second request it offered Let in place of var
-
displaying map/location in iframe in Ninox.
Is there a sample DB that has an iframe that shows Google Maps of a location field in Ninox? If not can anyone help with a solution? In other words once a location is found a formula field displays…
- Answered
-
Laptop vs iPad
Hi, I have a database with code. When I perform a certain action (processing and saving) it takes about 4 seconds on my laptop and less than a second on my iPad.…
-
Ninext : Important information
This message is addressed to all those who use the Ninext project. I regret to announce that the Ninext project will be unusable on Ninox very soon. This should happen at the beginning of February.…
-
Hide button if selection in Multiple Choice
I need to make the button "ESENZIONE BOLLA" appear only if the flag is active on DAF FF 058 PS 2600KG in the dynamic multiple choice field. Otherwise I need to hide it.…
- Answered
-
Converting a text string to a multiple choice field
Hello! I've been having trouble figuring this out and I would love some help. I have a work flow that involves a potential guest (school groups visiting our site) filling out a form that…
- Answered
-
Enter the content of another field inside a rich text field
Hello again. I'm just ending the development of a custom application that needs to print and export some rich text fields with lots of text. What I need is some kind of "data merge" inside a rich…
-
Change lookup field based on the year
I need to look up one of two fields depending on the year. The two fields are labeled as follows: ‘2022-HHG-Mileage’ and ‘2023-HHG-Mileage’. Then, the correct field name needs to be inserted in the…
- Answered
-
Sort a dMC field dynamic values
I've tried adding Sort() to the select station and also the Dynamic Value field and neither seems to work. Anyone know if this is possible?
- Answered
-
Styling a portion of a formula
I have tried this without success so far. Is there a way to Style 'Files' only bit in this formula. Files is a formula given the number of attachments for this record.…
-
Issue with creating related record from script
I have a Combox that a user can apply "Tasks" to the Client they are working with and normally that occurs from a Triggered Update within a form in the Clients Table.…
-
Ninext : Native JavaScript
I start here a new post about the Native JavaScrip to differentiate it from the EvalJS function in which I had previously put it... I discovered one weekago that it was possible to add comments in…
-
How to clear/null a reference combo box
I've created a combo box/reference that will allow me to create tasks for a record from a list of selections. The field in the main record "Project" has a combo box called "Tasks to Apply" and when a…
- Answered
-
Two condition nested If not working
I am trying to color a field when days overdue (delta_days) is the below however with the below code, I get either red or green, never Yellow. The second else/if should be skipped when the number for…
- Answered
-
Mutually exclusive choices
Hello forum, I have an extremely basic question. Imagine a list where each item should be assigned one and only one value. In my experience this ought to be the use case for a "radio button",…
- Answered
-
Embedded Vimeo videos
Hello everyone, I'm trying to integrate videos from Vimeo on a Ninox form. The problem is that my videos are limited to specific domains so they can't be seen by anyone.…
-
Customized button
Hello everybody, I added the buttonEvent to Ninext. This allows to dynamically change the caption, the color and the help title of a button. Just add the onUpdate function in the "Display field only,…