Skip to main content
Ninox-Website
Ninox-Documentation
How to enable Javascript
Sign Up
Log in
Learn & Share
Get help
Webinars
All topics
Contact
Privacy
Overview
Profile
Alain Fontaine
Alain_Fontaine
390
72
2
Joined: Thu Jun 04 08:38:45 UTC 2020
Follow
My Posts
Latest Posts
Re: Timestamp UTC/GMT - formatted in english
I have used the following formula to get an UTC timestamp in the iOS App. I don“t know if it works in the Mac OS App. Since it is a timestamp value, it can be formatted to your liking.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Learn & Share
Reported - view
Re: Two questions
So, you have a “Locations” table, and references (N:1) to it from the two other tables. Do you have a reference (N:1) from the “Components” table to the “Setups” table? If this is the case,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Two questions
If you create a reference between the “Components” table and the “Setup” table: 1) when a component is part of a setup, the location attached to the setup will be visible from each component (that“s…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
When looking again at an old question, one often sees new options. So please let me first look back at the last july problem. It will help for solving the new one.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: N:M relation in a view
Cascading select commands on a single line should better be avoided. Reasoning on the context of each evaluation tends to become intractable. What are the relations between the tables “Invoice”,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: How to add years to a date based on a choice value field
Let“s suppose that your choices are 1, 2, 3, 5 and 10 years. First define a choice field, with as options the texts you want to have displayed, like for example ”1 year“, ”2 years“, etc.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Referenced tables
Tap on the header of the table. A dialog will appear where you can select the fields to be displayed. If you want your modifications to hold, you should first tap the wrench in the upper right corner…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: How to add years to a date based on a choice value field
The second script should contain “+ 10”, of course...
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: How to add years to a date based on a choice value field
Another possibilty: since you need to add either five or ten years, you could define two buttons. The code for each button would be: let StartDate := max(MfgDate, FirstUseDate);EndDate :…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: make a field read only
If you need to make a field read-only unconditionally, just put “false” in the “Writable if” option.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Update multiple records in one table with a record from a referenced table?
Very interesting. I just checked, and this trick also works in an assignation in a script. So a record handle is not required, but just the record reference number suffices.…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Update multiple records in one table with a record from a referenced table?
The purpose of the select command is to get a handle to the desired record in table “Location”. Another solution is to look up the ID of the desired record, and to put in the formula filed:…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Update multiple records in one table with a record from a referenced table?
You can do it with “Update multiple records”. - Select and display the records of table “Item” that must be updated; - “Update multiple records”; - select “Assign calculated value” for the reference…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: How to duplicate a record with reference to the original one?
let me := this; d.(“Link to” := me)
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: copy one record from a table to another table and also and copy/link the existing link to the same client
If “Acc Link” is the name of the N:1 reference field (your image is not visible), then: let xAccLink := “Acc Link” ; i.(“Acc Link” := xAccLink)
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Simple lookup script for returning a price on a table
Mmmmm, the third line is not exactly what I sent, so I am not suprised that it does not work correctly. Anyway, that third line should be replaced by the simpler version below,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Simple lookup script for returning a price on a table
It would be better to replace the two occurences of “>” by “>=”...
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Simple lookup script for returning a price on a table
Let“s suppose that the table containing the prices is called ”Measures“. The script below is intended to be the ”On click“ item of a button located in another table,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)
After the “duplicate” command, you can address the fields of the new record with the notation: newRecord.field1 := .... newRecord.field2 := ... The openRecord command opens the specified record,…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Trigger YES/NO formula if value already present in DB
Just remove “ > 1”.
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Duplicate a record and killing related records etc.(oh and jumping to that new record)
let newRecord := duplicate(this); openRecord(newRecord)
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Trigger YES/NO formula if value already present in DB
Let“s that your table is named ”myTable“, and that the field containing the phone number is named, well, ”Phone“. A formula to detect if the same number exists would be something like: let zPhone :…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: I need to copy one date field to another but only the first time the source field is populated... how / is this possible?
Would this, as “Trigger on update” of field “Listing Date”, lead to the result you want: if “Original Listing Date” = null then “Original Listing Date” := “Listing Date”end
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Sequential numbering
Something similar has been discussed here:…
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
Re: Show filtered table records in a view in different table
Altering the quotes seems to be a new vagary here. Go figure...
Alain Fontaine
Alain_Fontaine
3 yrs ago
Get help
Reported - view
1
10
11
12
13
14
15
16
Ninox-Website
Ninox-Documentation
Overview
Learn & Share
Get help
Webinars
View all topics