Alain Fontaine

Alain_Fontaine

Joined: Thu Jun 04 08:38:45 UTC 2020

My Posts

Latest Posts

Re: Expiration date in colour
As far as I understand the matter, it is not possible to set the colo(u)r of a data field. it is only possibke to set the style of a function field, because the formatting is done by including the…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Creating serial numbers for group and sub groups
Using number(Id) is indeed a good way to get unique serial numbers. If, in your business case, you need serial numbers that start at "1" for each group inside a box,…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to extract numbers from a field record
The scope of a variable (its "life") depends on the context. In general, the scope of a variable declared (by "let" or "var") in a function field or of a button definition is that definition.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to extract numbers from a field record
Sorry, I did not read your question correctly. Since it appears that 'Field 1' and all are actually fields in your table, just remove the three instances of "let",…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to extract numbers from a field record
You did not tell what you want to do with the three extracted numbers. So I submitted a code snippet that just sets three variables. If you allow the script to finish without doing anything with…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Creating serial numbers for group and sub groups
You don't say much about the structure of your database. Is it: - one table for boxes - one table for groups - one table for subjects - with n:1 links from subjects to groups and from groups to boxes…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to extract numbers from a field record
Regular expressions, and their use in Ninox, are a bit tricky. Here is a proposal for a solution, there are certainly many other possibilities: let tnumb := split(extractx('Subject Name',…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Check Code syntax
I would like to help, but I need to understand what you are trying to do. Is there a mySKU field in the table?
- Alain_Fontaine
- 4 yrs ago
- Learn and share
- Reported - view
Re: return Vat % by using select
What you could do is to have a link between the tables, but copy the needed values upon selection. Something similar has been discussed here: https://ninox.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How filter records with same field value
Before considering a redesign of your database, there are some things you could try to see if they give acceptable results. 1- create a list view in the Treatments table ;…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to display a field based on a field value?
text('employment status') = "student"
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Trigger on create (not working?_
Are you sure that the script is not executed? If you don't see the expected result, it could be because "JobDockets", which seems to be a reference, has not (yet) got a value.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How to use the "Form" option in "Views"
You may also want to review this thread:…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: How filter records with same field value
It depends on how you want the result to be presented. If you are happy with a field containing the list of unique treatments, you can put this in a formula field: concat(unique(Treatments.…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Text / Date calculations
It works, but don't hesitate to use the regex solution instead. It should be more robust, if for example a leading space appears from nowhere, of if a day or month lacks the leading zero.
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Text / Date calculations
Maybe: let dateArr := split(substr(esd, 0, 10), "-");date(number(item(dateArr, 0)), number(item(dateArr, 1)), number(item(dateArr, 2)))
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Multiple Choice Facts
Interesting summary. One little thing: in my experience, it seems that writing text('Multiple choice') is a simpler way to get what is shown as the result of concat(text('Multiple choice')).…
- Alain_Fontaine
- 4 yrs ago
- Learn and share
- Reported - view
Re: Remaining to a date & style
If you mean that the colour and icon must be shown when Countdown is exactly equal to 6: let Countdown := round((today() - 'Data d''inici') / 86400000);styled(text(Countdown) + " days",…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Remaining to a date & style
Where does this 1:00 come from? A possible explanation: "Countdown" is computed as the difference between two timestamps. The timestamp "today()" is represented internally as the number of…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for On Click field to change the value manually by typing that is display from a reference table.
Since the Length, Width and Heigth fields must be Number fields for this solution to work, they are indeed changeable. The role of the script is only to write the default values when a "Carton"…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Formula for On Click field to change the value manually by typing that is display from a reference table.
Just to add some diversity... Since the "Carton" table is linked, I suppose that you have, in the "Shipments" table, a n:1 reference field called, by default, "Carton".…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: HELP! What is wrong with my code? Trigger after update problems
I am not sure to fully understand what you want to do, but here are a few things that seem to need attention. if 'Salvage SP' = 0 or 2 then -> if 'Salvage SP' = 0 or 'Salvage SP' = 2 then if 'Salvage…
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: Automatically Import data from a related table based on the name of a given string.
This subject is covered here: https://ninox.com/en/manual/import-and-export/importing-linked-data
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes
Ockam's razor is still sharp. Would you believe that this single-liner does the job: Events['before today'].('artist paid' := true)
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view
Re: how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes
Just for the record, an even simpler script: for e in Events['before today'] doe.('artist paid' := true)end
- Alain_Fontaine
- 4 yrs ago
- Get help
- Reported - view

1 11 12 13 14 15 16 17

Welcome to the Ninox community

Alain Fontaine

My Posts

Re: Expiration date in colour

Re: Creating serial numbers for group and sub groups

Re: How to extract numbers from a field record

Re: How to extract numbers from a field record

Re: How to extract numbers from a field record

Re: Creating serial numbers for group and sub groups

Re: How to extract numbers from a field record

Re: Check Code syntax

Re: return Vat % by using select

Re: How filter records with same field value

Re: How to display a field based on a field value?

Re: Trigger on create (not working?_

Re: How to use the "Form" option in "Views"

Re: How filter records with same field value

Re: Text / Date calculations

Re: Text / Date calculations

Re: Multiple Choice Facts

Re: Remaining to a date & style

Re: Remaining to a date & style

Re: Formula for On Click field to change the value manually by typing that is display from a reference table.

Re: Formula for On Click field to change the value manually by typing that is display from a reference table.

Re: HELP! What is wrong with my code? Trigger after update problems

Re: Automatically Import data from a related table based on the name of a given string.

Re: how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes

Re: how to make a button in "table 1", change a no to a yes in a "table 2", depending if a different formula in "table 2" is = Yes

Overview