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
3381
534
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: duplicate bug?
@Nick well, i stand corrected. I guess i don't use the duplicate() command so didn't know it was changed. Thanks for the correction.
Fred
Fred
11 mths ago
1
Get help
Reported - view
Re: duplicate bug?
Duplicate() has never duplicated related records, so it is not really a bug. :) Do other DBs with a duplicate function also duplicate related records?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Records filtered by Dynamic Multiple Choice
@Dave IrvingI get confused by contains() as well. How I remember it is the large pool that you want to look in is first and the single item you want to look for is second.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Records filtered by Dynamic Multiple Choice
Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Luckily now you can use the contains() function to filter on arrays, so maybe try:…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Differenz zweier Datensätze berechnen
What are you looking for? The number of days between 31 Dec 2023 and 31 Dec 2019? or the number of years? number of months?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Submit button with required fields notification.
@Michal Bor You just need to expand the list of fields that you copy, Shop being one of them.
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Dialog on Trigger on new record
@Alan Cooke said: Am I correct that a Dialog will not work (cloud version) when creating a new record. You are correct all code in Trigger on New Record for the cloud version will run server side,…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).
@我是我的我 Maybe you can sharing your solution with the group?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).
@我是我的我 said: I guess it's because of the "if2" that was added. How can I adjust it to make them both work, I would agree that key2 doesn't work like key1 because of the second if statement.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Submit button with required fields notification.
@Michal Bor said: There is a problem, it kind of creates two records when I click on the button. Please see the picture, in one record it has selected the Shop and in second it does not,…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Find the minimum value in a group of records
@frsalabert said: Is there a way to do the same in my table ‘options’, in the formula column « ranking », and display a smile if the seller is equal to the minimum price in a dedicated power category,…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Submit button with required fields notification.
You don't say if the users are filling out a dashboard/page or creating a record directly in the table. I'm going to assume that you are using a dashboard since you always want to limit direct user…
Attachment
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Find the minimum value in a group of records
On your Dashboard table you can try this in a new view element: let a := (select Options); let x := unique(a.Puissance); for loop1 in x do first(a[Puissance = loop1] order by Couts) end;…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).
I need to run the "if2" code after meeting the "if1" condition "avg(test) = 1", and this code needs to be before "table2.Table3.(Choose := 2)". I don't quite understand what you want to happen.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Warning on button coding: "Field must return dynamic values..."
@Marisol Echaide I didn't test out the code without the first() command. Ninox doesn't give an error when you don't have the first() command but then an array is passed to the dynamic choice field…
Fred
Fred
11 mths ago
1
Get help
Reported - view
Re: Frustrating time tracking down error fieldnames.
They are now showing you fields from your linked tables sorted by links.
Fred
Fred
11 mths ago
Learn and share
Reported - view
Re: Warning on button coding: "Field must return dynamic values..."
You can change first to number and it should work. gasto.('Categoría' := number(select 'Servicios Contratados' where Proveedores = 34)); When you do a select you get back table id and record id.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Warning on button coding: "Field must return dynamic values..."
can you post a sample DB, one without personal data?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to use code to edit out unique non-repeating random numbers?
@我是我的我 I'm not sure what you want to do. You ask to "edit out unique non-repeating random numbers". Then you give a string that has numbers and letters.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: How to use code to edit out unique non-repeating random numbers?
Can you provide a sample of the data?
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Trigger after update & Alert anomaly
@spinner. 7580 Sorry if I gave the impression to wrap the script in a do as server. That will definitely make any script with an alert() function not show up.…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
But to answer your first question. You can put this in the dynamic field in Audit Plan. let t := this; select 'Phases to Audit' where 'Areas to Audit'.Areas = t.…
Fred
Fred
11 mths ago
1
Get help
Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
@Rafael I'm talking about adding one under Audit Plan.
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn
Just wondering, shouldn't there be a Phases subtable of Audit Plan? You would create a new record for each phase to be audited? That way you can update each phase as they are audited?…
Fred
Fred
11 mths ago
Get help
Reported - view
Re: Dropdown menu on database icon not working
Once they made the app free, I saw that as a sign that it will not always be updated as quickly as the browser version. So I made the leap to a public cloud account.…
Fred
Fred
11 mths ago
Get help
Reported - view
1
37
38
39
40
41
136
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
