Contact Sales to request a demo
Request demo
Product
Platforms
Templates
Security
Customer Reviews
Product Updates
Solutions
Success Stories
Partners
Partners
Become Our Partner
Pricing
Support
Help Center
Webinars
Hero Webinar
Manual
Forum
Tutorial Videos
Blog
Contact us
Search
How to enable Javascript
Sign Up
Log in
Support
Forum
Home
Search the community
Home
Learn & Share
Get help
Webinars
Knowledge Base
Latest Activity
Contact Us
Privacy
Home
Latest Posts
Re: Subtotals
Sometimes, after building a solution to a problem, further study reveals that the first try can by streamlined. In this case, a much simpler solution is indeed possible…
Attachment
Alain Fontaine
Alain_Fontaine
2 days ago
1
Learn & Share
Reported - view
Re: Subtotals
In the design of a relational database, one creates tables to model some objects in the real world, and then defines links to represent the relations between those objects.…
Attachment
Alain Fontaine
Alain_Fontaine
3 days ago
Learn & Share
Reported - view
Re: Subtotals
No proposals yet? Let try something… From the formulas listed, it seems that a relation exists between "Activity" and "Ingredients"; I supposed that one also exists between "Tickets" and "Activity",…
Attachment
Alain Fontaine
Alain_Fontaine
6 days ago
1
Learn & Share
Reported - view
Re: More Vieweirdness
Really strange indeed. If you replace text() by its explicit development: concat(for i in numbers('Multiple choice (dynamic)') do record(Table2,i).Text end) you get exactly the same value,…
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: Rich Text Field frustration - help :-(
Rich text in Ninox is actually interpreted html. This small database shows the relations between the raw and interpreted versions. You can do anything html can do.…
Attachment
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: multiple conditions is Display if:
Either: not (x or y or z or …) or: not x and not y and not z and …
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: Iterate over DC
It is possible to extend the model with dynamic selections.
Attachment
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: Iterate over DC
Do you mean something like this:
Attachment
Alain Fontaine
Alain_Fontaine
2 mths ago
Get help
Reported - view
Re: Sort / Order by based on total count
You could perhaps try something like: let lieferantName := record('ProjektStückliste',number('Lieferant Auswahl')).Lieferant; let nennweite := record('ProjektStückliste',number('Nennweite Auswahl')).…
Alain Fontaine
Alain_Fontaine
3 mths ago
1
Get help
Reported - view
Re: How to select current register within 'select' function
I tried to explain my understanding of this issue here: https://forum.ninox.com/t/h7hrz3a?r=83hrsl3
Alain Fontaine
Alain_Fontaine
3 mths ago
Get help
Reported - view
Re: Show "1" instead UNDEFINED
You could try: if trim(x) = "undefined" then… P.S. "debugValueInfo()" is your friend.
Alain Fontaine
Alain_Fontaine
3 mths ago
1
Get help
Reported - view
Re: Need Help with view table.
When no search field is filled, this option is selected: case "": (select Data) You could try: case "": (select Data)[false]
Alain Fontaine
Alain_Fontaine
3 mths ago
1
Get help
Reported - view
Re: Track selection of Dynamic Multiple Choice field
@Fred In had to solve a similar problem some time ago. Here is a small database I made to test two possible solutions.
Attachment
Alain Fontaine
Alain_Fontaine
6 mths ago
2
Learn & Share
Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@John Halls Here is the minimum mockup I made to test the idea.
Attachment
Alain Fontaine
Alain_Fontaine
8 mths ago
1
Get help
Reported - view
Re: Creating a Button That Goes to Table with only Linked Records
@John Halls I did not test this on a large database, but it is possible that the variant below could be somewhat faster: let cId := ClientId; (select Chronos)[Subset].(Subset := null); Chronos.…
Alain Fontaine
Alain_Fontaine
8 mths ago
Get help
Reported - view
Re: Cascading Selection Fields with a twist
@Gianluca This solution is only possible because there are very few - actually two - possibilities. While working with the choices, I noticed that gigantic switch statement triggered by "Mansione".…
Attachment
Alain Fontaine
Alain_Fontaine
9 mths ago
1
Get help
Reported - view
Re: Cascading Selection Fields with a twist
Yet another problem that would be easy to solve if one could access the fields of the host record from inside a construct that changes the context. In this case, one could:…
Attachment
Alain Fontaine
Alain_Fontaine
9 mths ago
2
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
For a dynamic choice field, the number returned is always the reference number (aka "Id") of the record in the "source" table providing the chosen item.…
Alain Fontaine
Alain_Fontaine
11 mths ago
2
Get help
Reported - view
Re: All I want for Christmas!
A "single record view". The existing "view" layout element allows to display a set (technically, an array) of records defined by a formula. Its operates much like a 1:N reference field,…
Alain Fontaine
Alain_Fontaine
11 mths ago
Get help
Reported - view
Re: All I want for Christmas!
Arguing with myself (senility ?)… If such an option would exist, the context for the script execution would certainly be the target record itself. Which means that the fields of that record would be…
Alain Fontaine
Alain_Fontaine
11 mths ago
Get help
Reported - view
Re: Choose more than one?
@John Halls Not a one-liner yet, but close
.
Alain Fontaine
Alain_Fontaine
11 mths ago
2
Get help
Reported - view
Re: Search with Multiple Choice problem
@Rafael In the "No Emitidos" view, there is a filter on the "FechaR1" column. Only the lines where this field is empty would be displayed, in addition to the conditions set in the formula.
Alain Fontaine
Alain_Fontaine
11 mths ago
Get help
Reported - view
Re: Search with Multiple Choice problem
@Rafael If you want to see the records of the table "Documentos" whose selected date falls in the stated interval AND where the field "Ganado REAL" is "null",…
Alain Fontaine
Alain_Fontaine
11 mths ago
Get help
Reported - view
Re: Dynamic Choice Field reference in a function
Everything Lars said about "select" always returning an array is true. But did you notice that your original formula did work without specifying "first(…)"? Sometimes,…
Alain Fontaine
Alain_Fontaine
11 mths ago
2
Get help
Reported - view
Re: Search with Multiple Choice problem
@Fred The magic lies in the expression: b[=t]. Its effect is to filter the array "b", keeping only the elements that satisfy the condition inside the square brackets, in this case,…
Alain Fontaine
Alain_Fontaine
11 mths ago
1
Get help
Reported - view
1
2
3
4
5
14
Next
Alain Fontaine
Alain_Fontaine
330
43
2
Joined: 04 Jun 2020
Follow
Home
Learn & Share
Get help
Webinars
View all topics
Tags