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
3527
551
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Creating a new record in a linked table using code
@spinner. 7580 said: Attaching sample DB I've taken a look. I've added a dashboard (Data Entry), since, for me, it makes the most sense to have a data entry form that is separate from Routes.…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: MAJOR problem (v3.7.14 Mac)
Wow that is NOT good. I just switched to a cloud account, so I won't have this possible issue. Just the other issue of corrupt data when deleting records in the root table of a dynamic multi choice…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script for Inventory
Take a look at the changes I made in the DB. I made a new button and put this for the onClick: let t := this; let xSel := record(Familles_Produit,number('Familles Produit')); if 'Familles Produit' !…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Styling a portion of a formula
@Alan Cooke
Ninox does not like if statements with two different type of responses. The “then” was a text response and the “else” was html. You fixed it by making both html.
Fred
Fred
2 yrs ago
1
Learn and share
Reported - view
Re: Ninox Date and Time Issues (continued)
@Jacques TUR as always, thanks for the info about a Ninox function that is not documented, or easy to find.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Ninox Date and Time Issues (continued)
Is Time a time field? or a number field?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Ninox Date and Time Issues (continued)
So you are trying to filter records equal to Jan 17, 2023 but before 12:00pm? what is the code behind your extractDate() function? When I troubleshoot a select filter I use another formula field and…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Enter the content of another field inside a rich text field
A third option is to use the trigger after update at the table level. A fourth option is to use a formula field and html() command to combine text fields and use html to format individual parts.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Issue with creating related record from script
The issue is with the variable thisProject. You have it set to "this". So of course it works in the Clients table, but when copied over to the Trips table it fails.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Issue with creating related record from script
@Holly M said: but the error is now showing on the ) That is unusual. If possible can you post the full code? I'm wondering how thisProject is set.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Issue with creating related record from script
@Holly M said: for clarity the fully qualified name would be Trips.Client and Trips.Clients It doesn't matter what table we start in since you are in the Tasks table when you create a new record…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script for Inventory
1) How do you want Families Produit to be filtered by Type de selection? Families Produit is a dynamic multi choice (dMC) field pointing to Families_Produit table.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Issue with creating related record from script
In the table Tasks, what is the name of the reference field to Clients?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Unable to populate related table in Choice (dynamic) field
@Richard v. L. said: I can't understand why I can't reference my "Source" and "Target" languages directly from "Speeches" It is because Terms and Speeches are too distantly related and with too many…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: use array or better selection query?
This line doesn’t work: let selection := myarray[dischargedate > admitdate] because dischargedate and admitdate are arrays as well. Since admit and discharge are arrays,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: Not sure of how to upload DB - to you privately or posted online? If you are using the App with a local/iCloud DB then click on the upper right of the DB icon and select Save…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script for Inventory
@Didier Schoonjans said: I want to give you a copy of my DB, but how do I do it? If you are using the App with a local/iCloud DB then click on the upper right of the DB icon and select Save archive…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Script for Inventory
@Didier Schoonjans said: I have already planned everything, but I finally lack a script that launches the "automatic" selection of all the articles on the "Item Code".…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: On-Premise: select + order by Syntax
@F. Schwendtner I wouldn’t hold my breath for a quick fix. :)
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: On-Premise: select + order by Syntax
For some reason Ninox is picky with a variable. Put quotes around the select statement. let a := (select Lifecycle where 'Gerät / Hardware' = 189 order by 'Lieferdatum Kunde');…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Styling a portion of a formula
I’m guessing using HTML you can. But one of our HTML wizards would have to respond.
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: For example if I did a 53.2 mile ride I enter 53 in a field called Route Base Miles, I get a table with all of the routes that are equal to 53 and less than 54.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Creation Date
@Chris Thomasson said: Would love to have this feature! Unfortunately, I don’t think it is working on iOS, which is what I use. Yes, I think they are available in the cloud version.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: More Vieweirdness
That is some great sleuthing @UKenGB ! Building on Alain's comment, the record() command is becoming one of my favorite commands when working with dynamic choice/multi choice fields.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Pass current viewing record Id to a view element column formula
@Terry Hopper What notes from Ninox are you referencing?
Fred
Fred
2 yrs ago
Get help
Reported - view
1
81
82
83
84
85
142
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
Ninox does not like if statements with two different type of responses. The “then” was a text response and the “else” was html. You fixed it by making both html.