Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and Share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Mconneen
Mconneen
1140
13
1
Joined: Fri May 11 20:44:06 UTC 2018
Follow
My Posts
Latest Posts
Re: Choice change - Order status
AC Vuko d.o.o I would put logic in the part number's status After Update Trigger something like (code not tested) let t:=this;if count((select 'Part Number')[Status != 'Delivered']) = 0 then t.Order.…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Button/Timestamp
Crap.. hit post .. the rest of the screen shots.. :) Also.. please note.. if your Items table has views.. or is on other views.. After each update.. those views are re-evaluated (or at least that is…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Button/Timestamp
@Stefano, What platform are you running? Mac App, iPad, Web ??? I am on the Mac app.. I created 5000 item rows in about 25 seconds.. I then looped through each of the 5000 rows and copied one field…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Button/Timestamp
@Stefano I am a little confused. When you click the "Reset" button.. you execute the above described for loop.. What are you trying to accomplish with the Time Stamp formula ?…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Multiple choice picks in order?
@Gianluca ... Interesting use case.. I see that chosen('mc field name') does the same.. If the order of selection is important, I suppose you could build a hidden / composite table ..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Is it possible to fill a choice list from a table? Thanks
@Etienne You can display the contents of the Films table in a "view".. but clicking one will only drill into the film record, not populate the reference.…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Date field color
Here are a few snapshots.
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: How to make more than one selection for a single field linked to another table?
Etienne ... Bierger's webinar today was on this very topic.. You should be able to watch that shortly. Basically .. Composite tables are inside the parent table. When you delete the parent record..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: How to make more than one selection for a single field linked to another table?
Create a composit table within Films... call it Translator... Translator has a reference to person. From Films.. add translators.. :)
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Can I create a single view that contains fields from multiple tables?
What do you want that "view" to be? A form? A report? From the form perspective, you could add "views" and "subtables" as well as use formula fields to DISPLAY fields from multiple tables.…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Update multiple choice
Awesome.. +1 on the beer! LOL..
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Update multiple choice
@Sean... totally agree about the documentation... range appears to return an array of numbers.. I was going to point you to a niffty posting about array handling.. and when I looked up my notes..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Update multiple choice
@Steven... You are SOOOOOO close. Just drop the concat.. :) Button Mark Them All.. I only looked briefly.. would be nice to dynamically figure out how many values are in the multiple choice field..
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: De Jean Lebel
La page Web fait uniquement référence à l'anglais et à l'allemand (disclaimer.. From google translator)
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: open two databases simultaneously
Michel.. From my knowledge, that is correct.. I have seen other threads that refernce a hack to attempt to install / copy the application to a different name and thus have multiple local copies....…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Copy and Paste a column using a button
@Stefano While this is certainly possible.. I question the motivation... This sounds like an accounting credit / debit relationship.. If you simply "copy" the fields..…
Mconneen
Mconneen
5 yrs ago
Learn and Share
Reported - view
Re: open two databases simultaneously
Sure.. Navigate to the Ninox web page(where you are reading this).. and click "Start Ninox"... Then.. select a database to open (by default.. Ninox will open your last open database). Then..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Update multiple choice
Do you not see an "all" choice?
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: open two databases simultaneously
Michel... Using the web app (https://app.ninoxdb.de/) .. Yes you can.
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Make a formula field concider code as plain text
@Joelle.. sounds like Sean understood and pointed you to a similar link.
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Make a formula field concider code as plain text
@Sean.. No.. I think you are correct..
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Integrate with web page
@Alan, Here is a quick hack for an example. http://mconneen.infointegrators.net/ninox/ninoxEmbedded.html NOTE.. If you click on the above link long after this posting.. It may not resolve..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Make a formula field concider code as plain text
@Sean.. Ahh.. never would have interpreted it that way.. :) Thank you!
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Integrate with web page
@Alan.. You got me on that one.. You are correct.. It is an annual subscription. Not knowing the extent of your use case (aka your intentions).. still a bit hard to advise..
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
Re: Make a formula field concider code as plain text
@Joelle... I am a bit confused on your use case. @NinoxUS is 100% correct that you can put comments in quotes.. there is a debate as to if this should be done via assignment like..…
Mconneen
Mconneen
5 yrs ago
Get help
Reported - view
1
27
28
29
30
31
46
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics