Skip to main content
Forum
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
Updates & status
Plugins
Documentation
Setup
Databases
Automation
My account
Administration
Solutions
Ninox 4
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
Follow
Joined
Thu Feb 06 18:42:57 UTC 2020
3939
posts
639
likes received
5
followers
Badges
Latest Posts
Re: Dynamic Printing Table layout
It has finally taken me this long to find out that @Eichelfr was right all along and I just couldn't wrap my wee brain around his answer. So yes, you have to use Table Styles to have your table print…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Formatting a field
@Fernando Vivas Since @Nick separated the numbers into easy to use variables, you can just change the last line to: SSN := Num2 + "-" + Num3
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Record the previous day's figure
@iliper LTD can you tell me where this code is?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Record the previous day's figure
can you post a sample DB? if you can use a relationship then you can remove the need to match 'names'.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Is there a way to find overlapping appointments?
@Kruna If I read the script correctly, thanks to the easy read variable names, this is the heart of the code: xOverlap := count(select Assignments where TASK = thisRecord and 'ROLE PLAYER' =…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Trigger after update not triggered when updating by copy&paste
In my case (Ninox DB app on Mac) it fails whenever I copy & paste that one field With this new info, I went back and tested in my app on the Mac. It does fail like you reported if working on a local…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sorting Problem
@iliper LTD That is true. You have to do it in your code that puts the text and number fields together.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Sorting Problem
That is not a bug. When you mix text and numbers it is treated as text, so when you sort text you do it one letter/number at a time. That means there is no such thing as 10's or 100's.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Select from Choice Dynamic from button go to record in another table
FYI, if 'Document Choice' uses Document as the root table then you can use the record command to quickly get the same record and remove the select. let rD := record(Document,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Trigger after update not triggered when updating by copy&paste
I tried it again using a table Trigger after update (because I didn't read your original post thoroughly), though (imho) it seems like better served with a field level trigger.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Trigger after update not triggered when updating by copy&paste
@dennis I, too, was not able to reproduce your problem.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Dynamic Choice/Multi-Choice
@S Moore Since dynamic fields are based on tables, I wish they could also be JSON based, you will need to add a record called All Buildings and somehow mark it to show up in all your filters.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Dynamic Choice/Multi-Choice
What is the other option you want to add?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Weird do as server issues
Looks like it was my bad coding. 😗 The formula field had code that was: length(ActiveTeams.TeamEventSummary.RoundAnalysis[round = t.round and (var g := RiderIDs; text(g) = text(t.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Dashboard Template
@Sotirios Zormpas That is really cool. You have added a wealth of tools. Thanks, from the community.
Fred
Fred
2 yrs ago
2
Learn and share
Reported - view
Re: Ninox APP update problem
@RafaelJust wondering if you can you add data to date/time fields through a button? Not that this is a solution.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Ninox Products - App vs. Cloud
@James If you are worried about using the app with the cloud service and keeping things in sync then from my experience the app updates cloud DBs immediately and vice versa.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Deleting Images from the app and the server! (update)
@Rafael I like the Spotify link. Do you update the link manually or does Spotify have an api that you can use to search their inventory?
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Ninox APP update problem
@Rafael I've never clicked on that icon before. Thanks.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Hello
@Mario Cuzzi when you get a chance please mark this post”answered”. thanks.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Open 'Dashboard' view when opening Database
@Andy Hill When you get a chance, please mark the post Answered.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Hello
That is a very good question. You have to make fields like price, tax, discount, address, phone, etc all static fields (i.e. text, number, phone fields).…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Iphone layout
The easiest way is to use the ninoxApp() command in the Display only if of the fields you want to hide. If it is a dashboard you could create a tab that is set for the iphone then hide the other tab…
Fred
Fred
2 yrs ago
2
Get help
Reported - view
Re: Open 'Dashboard' view when opening Database
Forgot that you could have used a Page. If you did then use the openPage() command.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Open 'Dashboard' view when opening Database
That is where the command goes and it is the openTable() command.
Fred
Fred
2 yrs ago
Get help
Reported - view
1
34
35
36
37
38
158
Ninox-Website
Overview
Learn and share
Get help
Updates & status
Plugins
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Plugins
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
History
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Backups and storage
Process monitor
Solutions
Ninox E-Invoice
Ninox 4
View all topics