Mconneen

1140
13
1

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

My Posts

Latest Posts

Re: Call a button from a trigger
jim@jcschell.com ... Try this.. Create a field .. say "Validate Data Procedure". Move your button logic into 'Validate Data Procedure' trigger after update. Then...…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Call a button from a trigger
I like your use case... Lets state this a different way.... In NinoxDB.. Is there a way to create "global functions"? Within a single formula .. I can create multiple functions like..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Hello everyone, I am looking for a user manual for using this function; could anyone help me ??? thank you all
Do you review this ??? https://ninoxdb.de/en/manual/tables/views Following is a live example. I have a table to track my Statements Of Work (SOWS). I also have a table for Resources.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Do functions support the use of comments?

Do functions support the use of commetns within the code? Something like /* or -- .. or anything ... ?? Might be helpful.
- Mconneen
- 6 yrs ago
- 7replies
- 1896
- Get help
Re: Alert for debug purposes
Use the text() function to convert the value to a string. let a := today();alert(text(a));
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Unique Alpha-Numeric Formula
OK.. Hack 2 ... address the alternating pattern.. you can add a count select against the unique table source and put in an outer loop. ;) May not be the most elegant ..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Unique Alpha-Numeric Formula
OK.. First hack is as follows.. does not address the alternating alpha / numeric pattern.. nor does it address uniqueness of key value .. let alphaArray := ["A","B","C","D","E","F","G","H","I","J",…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
My pleassure preboredo .. I enjoyed learning a bit more about Ninox.. and it is easier to learn when having a use case... You can certainly extend the solution by creating a function to name the…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Unique Alpha-Numeric Formula
Create an array of the letters A thru Z.. in a while loop.... use the random function to randomly pick on of the array items.. Not sure if Ninox has an undocumented randbetween function like Excel…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: who can develop a small apple script to copy my notes content into a Ninox's text field
For the published script above.. Make sure notes.app is CLOSED (aka not running).. I got some strange results when the app was opened. This is only a quick hack..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
Here are the table defintions.. Student -> list of all students within the organization. Class --> list of all classess offered by the organization. Class.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: who can develop a small apple script to copy my notes content into a Ninox's text field
A couple of screen shots..
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: who can develop a small apple script to copy my notes content into a Ninox's text field
DISCLAIMER.. I have not used appleScript very much.. I pieced the following together from various sites.. I tried to reference them.. To use the script..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
OK.. This just struck me.. Evidently the code does NOT work on the Trigger on Create .. because when the row is "created" .. the association to the Session.Class does not yet exist....…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
I am SOOOOO close.. I tried this code in a Trigger on create in the Session table.. let s := this;for p in select Roster where Class = s.Class do let a := (create Attendance); a.(Session := s); a.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
OK.. this will take me a bit to test.... When creating a Class Session row... Have a create trigger that creates the Attendance subtable for that Session by select / inserting from the Class Roster..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Attendance record
I am not quite there yet.. First hack is as follows... the defect is that when taking attendance.. it shows ALL students. Second hack.. Have the Attendance subtable reference the class roster.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Suggest include modulo function in documentation
I agree.. the documentation is lacking! Thanks for pointing this function out.. I can use it!
- Mconneen
- 6 yrs ago
- Learn and Share
- Reported - view
Re: Calculate final date work days
Well.. I guess if it was let d := 6 - weekday('Start Date') .. I would not have to add 1 back at the end.. :)
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Calculate final date work days
I like to say that I often walk around the block to go next door... There may be an easier way.. but this will calculate an end date given a start date and a DURATION in workdays ..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: Rounding Formula
Thanks for hte "floor"... The manual is incorrect.. https://ninoxdb.de/en/manual/calculations/mathematical-functions It says round( x ) rounds x to the nearest whole number. round up( x ) rounds x up.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
How to account for holidays when calculating workdays?

Assume we are using the Project Template database.. A Project has a Beginning and an End function field that pulls the min / max of subproject dates. I added a Holiday table that has a HolidayDate…
- Mconneen
- 6 yrs ago
- 1reply
- 1503
- Learn and Share
Re: Transfer a Ninox DB
Thanks @Sakshi ... There is another thread about linking to a different database. When doing Acce$$ development, it is a best practice to split the application data and the application code.…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: How to display subtable of subtable on master table form?
OK.. Got a reply from support.. THANK YOU FOR PROMPT REPLY! AWESOME! So... I was all around it.. The part I missed was the data type of "Id".. Here is their reply..…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view
Re: How to display subtable of subtable on master table form?
OK.. Will do.. but it is pretty simple.. Using the Project template database... Add a view of to the Project form.. I want to display Tasks associated to the seleced project (via the projects sub…
- Mconneen
- 6 yrs ago
- Get help
- Reported - view

1 40 41 42 43 44 45 46

Welcome to the Ninox community

Mconneen

My Posts

Re: Call a button from a trigger

Re: Call a button from a trigger

Re: Hello everyone, I am looking for a user manual for using this function; could anyone help me ??? thank you all

Do functions support the use of comments?

Re: Alert for debug purposes

Re: Unique Alpha-Numeric Formula

Re: Unique Alpha-Numeric Formula

Re: Attendance record

Re: Unique Alpha-Numeric Formula

Re: who can develop a small apple script to copy my notes content into a Ninox's text field

Re: Attendance record

Re: who can develop a small apple script to copy my notes content into a Ninox's text field

Re: who can develop a small apple script to copy my notes content into a Ninox's text field

Re: Attendance record

Re: Attendance record

Re: Attendance record

Re: Attendance record

Re: Suggest include modulo function in documentation

Re: Calculate final date work days

Re: Calculate final date work days

Re: Rounding Formula

Re: Transfer a Ninox DB

Re: How to display subtable of subtable on master table form?

Re: How to display subtable of subtable on master table form?

Overview