Fred

San Francisco, USA

3701
591
5

Joined: Thu Feb 06 18:42:57 UTC 2020

My Posts

Latest Posts

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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Ninox will not open on my Mac
Try: Quit the Ninox app. open Terminal put this in the terminal app: defaults delete de.ninoxdb.ninox-mac.Ninox
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
@spinner. 7580Steven's link shows you where the action happens depending on where you make the call. So it says a Trigger after update happens at the server level for browsers and at the client level…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date format in formula
check out the Ninox doc on date(), you will see the proper date format of date(year, month, day).
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
@John Halls Very clever way of creating unique instances. I would have created three new variables to do the same thing.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Help with Changing Multiple If Statement to a Case Statement
you can also do: let t := 'Enrolled Date'; switch true do case Withdrawn = 0 and Graduated = 0: days(date('Enrolled Date'), today()) - cnt(select 'Academic Breaks' where Date >= t and Date <=…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view

1 50 51 52 53 54 149

Welcome to the Ninox community

Fred

My Posts

Re: Submit button with required fields notification.

Re: Dialog on Trigger on new record

Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).

Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).

Re: Submit button with required fields notification.

Re: Find the minimum value in a group of records

Re: Submit button with required fields notification.

Re: Find the minimum value in a group of records

Re: How to modify multiple if statements (I'm not sure if that's the right way to express it).

Re: Warning on button coding: "Field must return dynamic values..."

Re: Frustrating time tracking down error fieldnames.

Re: Warning on button coding: "Field must return dynamic values..."

Re: Warning on button coding: "Field must return dynamic values..."

Re: How to use code to edit out unique non-repeating random numbers?

Re: How to use code to edit out unique non-repeating random numbers?

Re: Trigger after update & Alert anomaly

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Select only the Phases to Audit by the Area Audit: Multiple Choice Dyn

Re: Dropdown menu on database icon not working

Re: Ninox will not open on my Mac

Re: Trigger after update & Alert anomaly

Re: Date format in formula

Re: Help with Changing Multiple If Statement to a Case Statement

Re: Help with Changing Multiple If Statement to a Case Statement

Overview