Mconneen

1140
13
1

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

My Posts

Latest Posts

Re: What is your preferred Data Validation Strategy.
@Remy, This topic did not generate too much interest. It could be that I posted it in the wrong portion of this forum. I do agree with you, if a "required field" is NULL,…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Associate multiple subtable entries with one main table entry
Not sure what you mean by "the fields lock up". What platform are you on? Web, Mac, iPad, ?? Here is the data model showing the composit relationship. Here is the main client form..…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Protected database
Not that I am aware of. Best you can do is import the tables and data into another database. That said, if there are global functions... you will not get those.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Error code doesn't make sense. What am I missing.
What is the error you are getting? You set RES1 as a string.. then it looks like you try to use it as a function RES1(j)
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
@Doug.. and it sounded like you wanted to change / create a new roster per week..
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Pulling data from linked table
@Doug, Not following the statement "I want the Roster table to also display the 2 fields; Salary and Points from the Players table.". The Roster table has a zero to many relationship with Player…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Filter to show only free company stuff
Yes.. You can create a constraint between the two tables such that only available staff are displayed. https://ninox.com/en/manual/tables/table-references-and-relations
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Edit formula with URL in print layout
Hmm.. I have not done a lot with printing... Perhaps try using a function that uses HTML .. and create an anchor tag .. No clue if that will work.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: on writing html web-links
Sure.. This shows a form with a few html items on it. And this is the click logic. You can do some pretty cool things in Ninox with HTML.. a bit beyon my skill level to "figure out" ..…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: on writing html web-links
Yes. There is a URL data type that can add to your table... and there is also an openURL(string) function that you can put behind a button.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: CreateCalendarReminder - Access not granted ---- how did you get around it?
Hmm.. I get the same. And, I do not see Ninox Database as an application requesting access to Reminders.
- Mconneen
- 4 yrs ago
- 1
- Get help
- Reported - view
Re: Tracking time automatically when the user opens a record
I am not fully aware of the "DEEP LINK" feature. It appears just an enhanced way to share table / linked table views. Perhaps you can get fancy with a javascript type timer...…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Tracking time automatically when the user opens a record
@SoluMaker I think you would have to design your forms such that you force your users to click something to open and close the form. You can then grab the current time and create a duration between…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Issue to link 2 tables
What does your data model look like? From what you are showing above.. you have only 1 table in the model.. "Table 1".
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: twin
With the Mac.. you can point to your iCloud.. and then access that via a free iPhone app. I am not much help when it comes to Android tho.. Sorry. This link talks about setting up your droid for…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Error in formula
Lost in the language.. I am not sure what line 1 is attempting. Is this a field formula ??? or a view formula?
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Error in formula
It is hard to see the select statement above.. but it looks incorrect.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Error in formula
You have two lines. Put a ; after the first line
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: To mask a field in the form ?
Not "out of the box" .. You have to account for it. For example.. Assume you you want to mask a person's social security number (SSN).. you can have a visible SSN field.. and a hidden SSN filed.…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Is there a way to enter the location based on a formula?
@Nick, Not following you... How does the delete / update API get triggered?
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Date greater than a certain date formula?
I don't use the graphic editor.. Looking at the documentation .. I see.. I suspect it would be 'Sold Date' > date(2020, 03, 30)
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
Yep.. sorry .. I should have been more clear .. evaluate the result of the formula in an appropriate trigger.
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
Sorry .. I see a type-o .. 'End Date" .. should be 'End Date'... disclaimer.. I did not test the code.. :)
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
Oh.. Yeah.. sure .. that is possible... you can just do something like ... let td := today(); if 'Begin Date' <= td and 'End Date">= td then Status := 3; end;…
- Mconneen
- 4 yrs ago
- Get help
- Reported - view
Re: Choice field and formula
@MP... Not following 100% ... So.. you have a choice field that has choices of RED, WHITE, BLUE .. and if the formula yields a number less than 100 .. you want the choices to be A, B, C instead?
- Mconneen
- 4 yrs ago
- Get help
- Reported - view

1 2 3 4 5 46

Welcome to the Ninox community

Mconneen

My Posts

Re: What is your preferred Data Validation Strategy.

Re: Associate multiple subtable entries with one main table entry

Re: Protected database

Re: Error code doesn't make sense. What am I missing.

Re: Pulling data from linked table

Re: Pulling data from linked table

Re: Filter to show only free company stuff

Re: Edit formula with URL in print layout

Re: on writing html web-links

Re: on writing html web-links

Re: CreateCalendarReminder - Access not granted ---- how did you get around it?

Re: Tracking time automatically when the user opens a record

Re: Tracking time automatically when the user opens a record

Re: Issue to link 2 tables

Re: twin

Re: Error in formula

Re: Error in formula

Re: Error in formula

Re: To mask a field in the form ?

Re: Is there a way to enter the location based on a formula?

Re: Date greater than a certain date formula?

Re: Choice field and formula

Re: Choice field and formula

Re: Choice field and formula

Re: Choice field and formula

Overview