Alan Cooke
-
Open a URL in a table from another table.
I have a table 'locations' in which I have a field (URL) to a OneDrive folder to display a file associated with a record (a room drawing). In a child table 'project equipment' I have a formula that…
-
Comments icon hi-lite like Attachments.
In another post wrt hiliting the paper clip this code was advised: if count(files(this)) != 0 then html(" <style> .i-light-grey.i-attachment { background-color: #a9a9a9; border-radius: 4px;…
-
field name with HTML formatting
Using a formula I want to set the size of an image (using "%" to set the size) on a form. That is to say I have a logo field in a settings table and refer to it in another form using a formula.…
-
Select a range of records within a table.
WWith say records from 1 to 100 how does one select all the records from 12 to 78? Is there a new method to do so? Similar to click and Shift+Click
-
Auto increment a number
I am using this script in the 'Trigger on Create' of a child table 'Invoice Line Items'. The field in this table is 'Line Number'. The Parent table is 'Invoices'.…
-
Move to field using Trigger after update
A simple I know but I'm brand new at coding in Ninox. I have a field 'Manufacturer' and a field 'Model Number'. I pick a manufacturer and then the model number in two steps.…
-
global function for user admin status
Coding is not my strong point at all so I need some help please. I want to create a global function that I can use dtabase wide where required that will for example make a button visible/invisble…
-
I have a field 'Renew By' which I want to change the background colour if the 'Renew By' date is after Today().
How do I achieve this as a formula Green if before and red if after Today()
-
Set a calendar event over a few days - looking for formula
In the now unavailable calendar template was a code sample to create a series of 'events' over a period automatically via a button. Does anyone have a sample of this code?…
-
Android phone not showing records
I have a Samsung S9 and using the Ninox App I do not get all my records displayed. All the tables are there, forms etc but some tables and forms do not show any records (#0 at bottom left).…
-
Subtracting 8 hours from a time worked field.
I have a formula field given the result of Date/Time Start and Date/Time end which works fine. For example such a result would be 9:00 (1 hour overtime given the day is 8 working hours).…
-
I would like to copy the contents of a field to the same field in the next record
Adding device details such as serial numbers. These could be all for one project in "Project Title". To save myself and user having to select the project tile repeatdy how would I creat a formula to…
-
How would I code/formula for a MAC address in a text field?
If I enter the following: 00107FCFD06FIs it possible to have it displayed like this: 00:10:7F:CF:D0:6F places : and force uppercase
-
MAC Address mask for input of text field
In my field of work, Audio Visual, we record MAC addresses. It would be very nice if one of the format options for a text field was for a MAC address. Typically: 00:10:7F:CF:D0:6F.…