Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and Share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Sean
Sean
1762
79
0
Joined: Tue Jul 31 23:45:13 UTC 2018
Follow
Coding Dart/Flutter in my spare time
My Posts
Latest Posts
Re: difference in the result when executing a script between a button and the action after updating a field
Not all actions can be run in a trigger. What are you trying to do?
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: How to create a field that consists of the last four digits of another field.
If a field name has a space in it, single quotes are required. When I tested the code, I used it in "Trigger after update". Are your fields in the same table?
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Image as a form layout element
Do you want the image to do something? I'm not sure what you're asking.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Relationships
That made me laugh
. Are you referring to hour long videos to explain something that should only take 5 minutes or enhancements that you have to pay an extra subscription fee for, or, or...
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: How to create a field that consists of the last four digits of another field.
The single quotes aren't necessary. I change the field names and forgot to delete the single quotes.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: How to create a field that consists of the last four digits of another field.
You're almost there. You can use this in the "Trigger after update" of source number field or in a button... let lastFour := extractx(text('Num1'), "\d{4}$");'Num2' := number(lastFour)
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Text / Date calculations
I apologize. I focused on the date and forgot about the time stamp. In addition to Alain's solution you have the option of using regex... let dateArr := split(extractx(esd, "\d+-\d+-\d+"), "-")
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Text / Date calculations
You can split the text date into year, month and day parts and use the date() function to convert it to a date type... let dateArr := split(YourTextDate, "/"); let dateFromText :…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Remaining to a date & style
Alain, I don't think I would have ever considered setting the switch expression to true to handle ranges. I'll probably use it more now that I'm aware of this trick!
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: How to lookup vehicle information based on vehicle ID number
Stephen, That screenshot is from the Ninox formula/code editor. All I did was take the unformatted JSON result and assigned it to a variable in a Formula field.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
Yes, you're right. I'm away from home and am using my phone as a mobile hotspot so I was looking at that IP address. I found my phone's public IPv4 and IPv6 public address using WhatIsMyIp.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
I was able to use the API without using "do as server". I kept my code simple and tested both the "text" and "json" response types... let response := http("GET", "https://api.ipify.org");response.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
I have to wonder if privacy concerns would be a deterrent to releasing that kind of function.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
Stephen, There aren't any exclusions that I'm aware of. The fastest way to get an invite is to send an email to Ninox support and if you don't have access to the Webinar EN 2020 team go ahead and ask…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to get internal information (like IP address / hardware (mac) address/ etc??
Stephen, There is a Change Request database in the Ninox BETA Team, but I wouldn't put much faith in any of the completion dates listed. I love working with the app, however,…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to sort by alpha and ignore the articles ("the", etc.)?
This appears to fix the sorting issue... extractx(Text, "(?:a |an |the )?(.+)", "i", "$1")
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to sort by alpha and ignore the articles ("the", etc.)?
Sorry, I should have tested more thoroughly. This line fixes the problem of not display records without a starting article, but I'm still seeing issues with the sorting.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Is there a way to sort by alpha and ignore the articles ("the", etc.)?
Yes, but you'll need to add a field to your table that you will sort by. In Table view you can move the new field off screen so it isn't seen. In Form view you can set the "Display field only, if:…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Commenting (Code)
Karen, I thought I needed to put a semicolon at the end of each line of a multiline comment too, but it's not necessary. I put this in a formula field and get the result of the arithmetic...…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Commenting (Code)
Agus, You don't need to set a comment to a variable. You only need to put the comment between double quotes and it can span multiple lines. You can add // or /* */, but it isn't necessary.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Console Error dynamic conversion of Single Quote Character to non-ascii character
I'm fairly confident I turned "Use smart quotes and dashes" off back when I first started using Ninox because of this problem. Maybe it was an OS update?
Thanks Steven and Nick.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Console Error dynamic conversion of Single Quote Character to non-ascii character
My thoughts are it's irritating AF! It does the same thing with the double quote. I haven't said anything because, lately, the response has been... the app is working as intended.
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Copy to Clibboard button
Hi Eric, This version allows for the ' character... html("<button onclick='copyToClipboard(""" + replace(FieldToCopy, "'", "%27") + """)'>Copy to clipboard</button><script>function…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: New button does not appear in old records
Hello, If you have the display of the Button elements tied to the Yes/No field they won't be displayed in the existing records because the Yes/No field doesn't have a value.…
Sean
Sean
4 yrs ago
Get help
Reported - view
Re: Copy to Clibboard button
The only sort-of-solution I found was this... html("<button onclick='copyToClipboard(""" + replace(FieldToCopy, "'", "") + """)'>Copy to clipboard</button><script>function copyToClipboard(str) {var…
Sean
Sean
4 yrs ago
Get help
Reported - view
1
26
27
28
29
30
71
Ninox-Website
Overview
Learn and Share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
. Are you referring to hour long videos to explain something that should only take 5 minutes or enhancements that you have to pay an extra subscription fee for, or, or...
