Mconneen

1140
13
1

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

My Posts

Latest Posts

Re: How does barcode scan function work ?
I am having issues scanning barcodes that are on a WHITE back ground... green / blue.. seem to work.. Any thoughts?
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Barcode scan
@John, I do not have anything I can (easily) scan... So I cannot prove this out... You should be able to add logic into you barcode after update trigger to close the current record and create a new…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Start daily counter from dropdown choice
Assuming your invoice has a field called 'Date Sent' that holds the date that it was sent... You can create a formula field called "Invoice Age" ... something like this.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to make a smaller save size with an archived database?
Well.. depending on your level of expertise.. Looks like you can consume a JSON feed within Excel / PowerQuery..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Changing the way date is displayed
sorry for the type-o's... I guess I was too excited.. :)
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Changing the way date is displayed
Hmm. DISCLAIMER.. I do not do much printing.. :) Do it this way.. Drop the formula idea.. not needed.. It will display on the datda entry form as a usual date type... Within you PDF designer ..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Changing the way date is displayed
Tim, The way to go is the formula.. It does take a little bit to retrain your mind.. but once you get the hang of it.. You can crank out some amazing apps rather quickly.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Converting leads to customer
@Alfredo.. In today's Inside Ninox Webinar, Bierger reviewed how to do this.. and also addressed copying the relationships..
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: How to modify or totally remove the global find button?
You can control what "Global Search" looks for based on the table and the table column.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Converting leads to customer
Sure.. you "could".... you could also add a "status" field to the "lead" and then add logic to the Status field's after update trigger such that when a lead moves to "won" (or whatever you want to…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: PROBLEM WITH DATA UPLOAD
@David.. LOL on the "Master" tag comment... I noticed some time ago that the forum simply counts the number of posts.. Let's just agree that you are very good at the Socratic Method of questioning..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Date manipulation
Not addressing leap year.. let d:= today();let m := 36;let endDate := date(year(d), month(d)+m, day(d));endDate
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Help with formula
What drives "the most recent value of Field B" ... Is it the last modified? Is it the last created? Or .. in Sean's example above.. is it the row that you are currently viewing?
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Maintenance mode
@David.. That is a greate use case. There are a few strategies .. In the database, go into admin mode (the wrench) and navigate to Security .. and set the open database to Admin role only.…
- Mconneen
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Creating an address block from different fields
@Sarah... No worries.. that is what the forum is for. There are also several Ninox Solution Partners that offer FREE YouTube channel (Ninox Learning) as well as pay as you go one on one training.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: This Forum Needs a Replacement.
+1
- Mconneen
- 5 yrs ago
- Learn and Share
- Reported - view
Re: Using the Kanban View to show only certian parts of the workflow
The after update trigger approach above is rather clean. Yes.. You have to define a "shadow field" and table view first.. Lets assume the pipeline status has 9 potential values.…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Using the Kanban View to show only certian parts of the workflow
Monions... The concept of the "workflow" and kanban is that the field that you are declaring the kanban view over represents each step. Why have superfluous steps if you do not want to see them?
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Showing all gifts for the last 12 months
Use someting like the following for the base of the view assuming you are using a year month boundary. Assume you have a table named Gifts.. and on that table you have your column 'Date Given'...…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Date Field Question.
@Mr. K... The date data type uses the system configured date format. So.. from an "input" perspective.. US dates are looking for Month Day Year. .. From an OUTPUT perspective..…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: is there a way to count number of item within a selection field?
Is this what you are looking for? cnt(chosen('Multiple choice'))
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Formula function displaying as a time interval in my table
@Ciaran... I am not following 100%.. The interval number of days between two dates simply tell you the number of days.. I would think you would take into account the number of effort hours.…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Data Model Question. Multiple table reference entries?
"give a man a fish and you feed him for a day; teach aman to fish and you feed him for a lifetime." .... Laozi
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: Dialog function when creating a new record
You are correct... the dialog function will NOT fire from the trigger. I recall in some other thread Ninox saying this was by design to mitigate some other issues.
- Mconneen
- 5 yrs ago
- Get help
- Reported - view
Re: send e-mail?
@Ivan.. While I have NOT tried this... Ninox uses SendGrid as their email service.. (at least I think they do) .. Looking at SendGrid site.. they offer an REST based email API https://sendgrid.…
- Mconneen
- 5 yrs ago
- Get help
- Reported - view

1 18 19 20 21 22 46

Welcome to the Ninox community

Mconneen

My Posts

Re: How does barcode scan function work ?

Re: Barcode scan

Re: Start daily counter from dropdown choice

Re: How to make a smaller save size with an archived database?

Re: Changing the way date is displayed

Re: Changing the way date is displayed

Re: Changing the way date is displayed

Re: Converting leads to customer

Re: How to modify or totally remove the global find button?

Re: Converting leads to customer

Re: PROBLEM WITH DATA UPLOAD

Re: Date manipulation

Re: Help with formula

Re: Maintenance mode

Re: Creating an address block from different fields

Re: This Forum Needs a Replacement.

Re: Using the Kanban View to show only certian parts of the workflow

Re: Using the Kanban View to show only certian parts of the workflow

Re: Showing all gifts for the last 12 months

Re: Date Field Question.

Re: is there a way to count number of item within a selection field?

Re: Formula function displaying as a time interval in my table

Re: Data Model Question. Multiple table reference entries?

Re: Dialog function when creating a new record

Re: send e-mail?

Overview