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
Fred
Fred
San Francisco, USA
3418
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Ancorare alcune colonne come su excel
what do you mean by anchor columns? Google Translate:
cosa intendi per colonne ancorate?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show "1" instead UNDEFINED
Yes, I always forget debugValueInfo. One day it will stick in my head.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Record create date function
I'm guessing you are using the cloud version since you mention users. You can use the Created On and Modified On function. See this Nioxus post for more info.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show "1" instead UNDEFINED
@thomas said: Thank! I've tried this too but I have as result "0" and not "1. Also if there is s value for $5 Can you check the code again? I looked at my example and typed the wrong code.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show "1" instead UNDEFINED
Please make the following change: if x = "undefined" then "1" else x end I forgot that extractx results is a string so you have to put " " around 1 so the result is also a string.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Show "1" instead UNDEFINED
You can try something like: let x := extractx....; if x = "undefined" then 1 else x end I’m not sure “undefined” is what Ninox sees or just what Ninox shows. You can try null as well.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Button for duplicate last records
You can try something like: let lastRec := last('Hourly Estimation'); let dupRec := duplicate(lastRec); dupRec.('Date+Time' := now()) This assumes that the record with the highest record Id in the…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Need Help with view table.
Since you are looking for people's name you need to use the field that stores the people's name. I'm guessing HORAS does not store people's name. Looking at your structure you need to use the…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create records automatically
You can try this in button in the Customer table: let t := this; let selExpiry := (select Expiry); let st := 'Society Tipology'; let neededExpiry := selExpiry['Which company?' = 1 or (var EfS :…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Date language
Ninox uses the date format of your computer settings. I haven’t played around with changing it to see how Ninox reacts, but you can try that. Or you can use the format command.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Need Help with view table.
@Rafael said: I need to know the hours spend on Data table for name place on the Search field. What is the name of the field that holds the name place? Use that.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Need Help with view table.
I try with this Formula sum the hours in Data Table for the people, I place in the Search field. But don't work any idea.? let search := lower(Search);…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Private Server
Ninox does have a private cloud option which is what the Connect to server... is for. This is where a company installs a multi user version of Ninox on their own hardware or Ninox hosts it for them.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Unique Value Formula
@RoSoft_Steven Thanks for lumping me in with @Jacques . Most of the time I’m just drafting in his wake. @Mel Charles , this site is good to test your RegX code. I haven’t found a good RegX tutorial.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Need Help with view table.
One way is to hide the view until there is something in the search fields. Another way is in the switch command there is a “default” case, so you can try putting null in there.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create records automatically
in the example you give, is there 15 records in the expiry table for customer AZName Ltd? So there is a N:1 relationship between Expiry (many) and customer (one) and a N:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Can you create such a button? With which code? You can do most things in Ninox. My little brain is having a hard time generalizing your workflow.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: How to create a unique list of records
Well @Jacques, your code makes a lot of sense and is much easier to use.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: How to create a unique list of records
I’ve wanted to do something like this for about a year now.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: How to create records automatically
@webmaster.antonioferriero said: Question. How to associate Fulfillment to each Customer? In other words, how to fill the Fulfillment table? Are you starting in the Fulfillment table,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Glad to hear it works for you. Please remember to mark this post answered.
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Once a record in WFM Permissions has more than one option selected in the multi…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Send email and include only fields with value
@Bernd Krell said: With 2 or 3 empty lines between, it looks odd. Any way to prevent this? I would say to play around with putting the carriage returns in the check formulas,…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice Field Assistance
Are Eligible Departments and Eligible Titles multi choice fields (thus the use of numbers)? Can thisuserdepartment and thisusertitle have more than 1 record?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
great to hear. You are on your way to master Ninox! Just remember to mark the post "answered".
Fred
Fred
2 yrs ago
1
Get help
Reported - view
1
85
86
87
88
89
137
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
cosa intendi per colonne ancorate?