How to enable Javascript

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