Fred's Profile | Ninox Community

Badges

Latest Posts

Re: globale Änderung eines Tabellennamens
Can you be more specific about what you mean by access Table X? By a reference field? Or do you have formulas? Wie schaffe ich es, dass die übrigen Tabellen nun auf die neue Tabelle A zugreifen und…
- Fred
- 1 yr ago
- Get help
- Reported - view
Weird browser constraint bug

Hi all - I've encountered a strange bug with the browser vs app with a constraint that is based on a choice field. I have reference field that has a constraint and it was working in February.…
- Fred
- 1 yr ago
- 1reply
- 36
- Learn and share
Re: Bizarre Results from Filtered Records
Reason is a multi choice field, so try putting numbers() around Reason. I created a field that did your code and got back these two records, plus a whole lot more: 4, 30,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Bizarre Results from Filtered Records
can you upload a sample db?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Create an appointment for next week
This works for me: Appointment := appointment(datetime(Date + 7), 3600000 * 4) Appointment is my appointment field. appointment() is the command to set an appointment field. Date is a date field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 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

1 54 55 56 57 58 153

Welcome to the Ninox community

Fred

Re: globale Änderung eines Tabellennamens

Re: Bizarre Results from Filtered Records

Re: Bizarre Results from Filtered Records

Re: Create an appointment for next week

Re: duplicate bug?

Re: duplicate bug?

Re: Records filtered by Dynamic Multiple Choice

Re: Records filtered by Dynamic Multiple Choice

Re: Differenz zweier Datensätze berechnen

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?

Overview