Skip to main content

Ninox-Documentation

Mconneen

Mconneen

1140
13
1

Joined: Fri May 11 20:44:06 UTC 2018

My Posts

Latest Posts

Re: How to jump to a specific tab in a tables record
Not that I know of.. You can "simulate" the same by setting the other tabs "Display field only, if" .. to false. Not ideal.. but is a work around.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Copy records ot a database to records of others records of another database
You can export them from Database 2 .. and import them into database 1. Will there be duplicates? If so.. make sure you have a matching logical key. If not.. During the import .. just let them add.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: List of errors
Not that I am aware of.. but that would be a GREAT enhancement.. :)
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Lookup table
Not sure why you are using BOTH the code AND the amount.. but it could be something like.. a.tax := first(select b [Code = a.code and Amount = a.amount])
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Changing colours
Some elements have a "style" setting (like buttons).. So to statically set the style.. you can use that. Some elements .. like Choice fields.. you can set a background color .. and icon..…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Calculate Minutes to hours
@angie What did not work? Use the timeinterval function ..
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: I can not get this global function to return useful info....am I missing something?
@Matt, Yes.. := is for assignment .... = is for equality check .. As for your other questions... Hard to answer without seeing your data model .. Ninox does run some open office hours (I think via…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Optain Bearer-Token Client-Side?
Yes .. a true oAuth 2x would be awesome.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: I can not get this global function to return useful info....am I missing something?
Sorry.. did not catch that in your first post of the funtion. :( But I guess that is how we learn.. make a mistake.. tear it down.. and build it back up..…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: I can not get this global function to return useful info....am I missing something?
postage_adjustment = 1 should be postage_adjustment := 1
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: how to use the button
@Peter From the manual https://ninox.com/en/manual/calculations/reference-of-functions-and-language Look for closeRecord() and openTable()
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: I can not get this global function to return useful info....am I missing something?
@Matthew First.. This line looks suspect let myweight := (select Products where SKU = myProduct).'Weight (g)'; it will return an array of weights.. might need a "first" there. Next ..…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Can you have a one to one relationship?
I wrote a quick application for a friends bakery to help him manage his paczki orders for Fat Tuesday. It looks like this.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Optain Bearer-Token Client-Side?
Ahh.. Now I (think I) understand... So.. to access Ninox via the RESTAPI, you must register and get an API key that you use to get the token. It is that API key that you do not want to hard code…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Ninox Community Group
@Bill I agree that FaceBook is NOT the platform for the support forum. Integromat is in there.. and I really do not like it.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: How can you, in code, make a post to the record's comments when a button is pressed?
@Jeremy As far as I recall.. there is not API or interface to the "comments" portion of Ninox. For such use cases, I have used a composite "comment" table under the record ....…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Attachments Selector or also Photo Viewer
Nice use case Steven.. Thank you!
- Mconneen
- 4 yrs ago
- Learn and share
- Reported - view
Re: Can you have a one to one relationship?
@Dean... you definently put more thought into it than I.. :) Sure.. I can see those as outlier conditions... especially with reference to BLOBs, PII obfuscation .. etc.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Can you have a one to one relationship?
@Matthew Let's address the first point.. One to One relationship.. While technically, yes.. you can create a relationship between two Ninox tables.. and use a constraint to enforce the one to one…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Search by date calendar?
Hmm.. what is "interesting" is that the "field" still has a global search check box.. Which.. gives the impression it should participate in the global search.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Search by date calendar?
@Mr K.. When you say "can't search for date using table search"... I think you mean "global search" (aka find). And you are right. A simple work around is to create a global search text filed and use…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Question on Trigger Script - automatically enrolling the students of a class when linking a course to the class
@Pierre and @Justin, Without thinking too hard about it... Sounds like a good use of a "constraint" on the look up logic to show only those students within the class.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Examples using SELECT
@Adrian There are a few double entry accounting examples in the various webinars. (see 041_Accounting System in the English Webninar Team). I also developed one for myself to track all my assets,…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Calculate Minutes to hours
Sorry.. hit post and forgot to upload image. :(
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Calculate Minutes to hours
@Angie So..if something is 72 minutes in duration .. do you want to know it is 1.2 hours (72/60) ... or do you want to know it is 1 hour and 12 minutes 1 : (72-60) ??
- Mconneen
- 4 yrs ago
- Get help
- Reported - view

1 3 4 5 6 7 46

Back to top

Ninox-Documentation

Overview

View all topics