Mconneen

1140
13
1

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

My Posts

Latest Posts

Re: Integrate with web page
Alan.. great question. I am interested in the repsonses as well as "integrate with web pages" can mean sooo many things. What I CAN tell you is that from an external web application you can access…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: how calculate date from year, week number and weekday?
@Agiorno... Here ya go.. The ever elusive modulo function.. :)…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: how calculate date from year, week number and weekday?
@Agiorno The function week('Booking Date') Will give you the week of the year.. I will have to dig through my notes.. There is a function that gives you the remainder..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to show AND link a 'last' field
@Ian.. Here is a very quick / dirty Kanban view.. I totally guessed at what the job status might be.. You can make this view your opening view.. or you can put it on an opening view dashboard /…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Where to write a global function
@Nils.. Yes.. the return value is either implied or explicit.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to show AND link a 'last' field
@Ian... OK.. As we like to say.. the devil is in the details.... or put another way, clearly outlining the use case is key. :) Just from the above, how about a Kanban card view of "Jobs"?…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Where to write a global function
@Nils Something like the following: let z:= getZScoreText(someNumberField);
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Date Fields
Not sure I follow... Are the two date fields on the same table row or are they in different TABLES? If the SAME table row.. you can use an after update trigger..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Can i change what is displayed in the Calendar?
hmm.. not sure if this is what you are after.. I am not 100% sure this will always work... Basically .. I created a date field... and selected "show on calendar" as YES...…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Unable to set column widths/sizes
Hmmm.. I do not see a width option in the Mac App either. I think it may be a documentation bug. Lets see what Support comes back with.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to show AND link a 'last' field
I am guessing you have a database that looks something like this.. And you have a Client view that looks something like this.. Assuming YES... The reason you see the Client record when clicking on it…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Auto Numbering Issue
@NinoxUS.. No length test needed .. use a format(subAutoNo, "000")... Now.. maybe a check to ensure you do not go over 999.. :)
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Where to write a global function
@Nils... To answer the question ... "where is the place to put a function if you want to use it again?: .... First go into admin mode (the wrench icon)...…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: lost data
@Caroline.... On which Ninox platform? If using the cloud.. it may have been backed up automatically for you. If on the Mac / iPad app.... then not sure..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to style Date/Time
Use the format function. format('Created on', "MM/DD/YYYY") https://ninoxdb.de/en/manual/calculations/reference-of-functions-and-language .. then find format(datetime, format) ..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
Looks good... Yep.. I have seen several requests for the tab order.. and .. as you might expect... it works differently based on platform (app, web, iPad, etc)..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Slowing database.
@Robert.. I have a cloud database that has several reference tables.. each over 21,000 rows.. and I do not see any performance issues... That said.. it did take a few minutes the first time I opened…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Button to local folder
@Robert... Good work around.. Thanks!
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Subtable - ordering system
@Nick.. oh.. by the way.. I have an enhancement request into Ninox such that this discussion group understand what the "@" means.. LOL.. Like what Slack, Teams, LinkedIN.. and that thing called "FB"..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Button to local folder
@bureaua.... Interesting use case.. I tried the "openURL" function with variations of openURL("file:///dir1/dir2/dir3"); openURL("file://localhost/foo/bar"); openURL("file://127.0.0.…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Moving fields between tabs???
@Nick.. This is interesting... I upgraded to 2.5.5. and I am on Mac OSX 10.13.6 (17G6030).. I am playing around in the Inventory database that I created from the templates some time ago.... .…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Moving fields between tabs???
@Nick.. Thanks.. I am still on 2.5.4 from March 26th.. LOL.. Did not catch there was yet another update.. Thanks I will upgrade and try again. Interestingly enough.. I tried it also in the web app..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How can I copy from a text field to a date field?
@bonniegruber.... You can also use the "split" or "splitx" function that will split the string into an array.. the "x" method uses a regular expression .. .…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Attachments
Not following 100%. You sort of just have attachments.. and you can programmatically add / remove them if you desire... I have seen other strategies of using an image field..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: File attachments
If you have file attachments clicked .. then the "attachment" tab / icon shows. If you unckeck it.. That tab/icon becomes invisible. Assuming you go back to the first image and UNCHECK "File…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view

1 28 29 30 31 32 46

Welcome to the Ninox community

Mconneen

My Posts

Re: Integrate with web page

Re: how calculate date from year, week number and weekday?

Re: how calculate date from year, week number and weekday?

Re: How to show AND link a 'last' field

Re: Where to write a global function

Re: How to show AND link a 'last' field

Re: Where to write a global function

Re: Date Fields

Re: Can i change what is displayed in the Calendar?

Re: Unable to set column widths/sizes

Re: How to show AND link a 'last' field

Re: Auto Numbering Issue

Re: Where to write a global function

Re: lost data

Re: How to style Date/Time

Re: Subtable - ordering system

Re: Slowing database.

Re: Button to local folder

Re: Subtable - ordering system

Re: Button to local folder

Re: Moving fields between tabs???

Re: Moving fields between tabs???

Re: How can I copy from a text field to a date field?

Re: Attachments

Re: File attachments

Overview