Fred's Profile | Ninox community

Badges

Latest Posts

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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs 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
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Duplicar archivo
@alfonso. mino. arribas Have you emailed Ninox support?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Trigger after update & Alert anomaly
I think you are running into the issue that Triggers happen at the server level so no alerts show to the end user. It is like wrapping your code with [do as server].…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How can I adjust this?
@我是我的我 said: I don't quite understand Fred. My initial selection was "Alcohol". The final table includes "beverage", which should be incorrect. I don't see beverage unless I select beverage.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Duplicar archivo
Just to be clear you are trying to duplicate a record? Are you using the duplicate button? I tried it on a public cloud DB and had no issue.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How can I adjust this?
If you put the following code in a new formula field: let s := this; let y := for loop1 in numbers(xxx) do record('copy here',loop1).name end; let x := (select 'copy here' where (var n := name;…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create record in another table on a switch
@Linda said: Klanten is a reference field in Reiskosten. But Klant(en) has a link in the table: Opdrachten. So when I make a new record in Uren, I choose a record from Opdrachten.…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 59 60 61 62 63 157

Welcome to the Ninox community

Fred

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

Re: Duplicar archivo

Re: Trigger after update & Alert anomaly

Re: How can I adjust this?

Re: Duplicar archivo

Re: How can I adjust this?

Re: Create record in another table on a switch

Overview