Fred's Profile | Ninox community

Badges

Latest Posts

Re: Group by equivalent
@UKenGB said: Basically, field1 and field2 contain many duplicate values and I want only unique combinations of them both, but also with all the field3 values of those unique field1 and field2…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Impression de plusieurs champs sur une ligne
here is an example of a child table showing up in the print view. here is the form view: GAMESTATS is the child table. and here is the print view: See how GAMESTATS is already in the print view.
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Impression de plusieurs champs sur une ligne
Take a look at your cloud DB. I created a new tab on the Facture client DB and created a new formula field with the following code: 'DSA 1'.'N° interne' + " " + 'DSA 1'.'Marque & modéle'.…
Attachment
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Views
@UKenGB oops, yes you are correct. brain fart on my end. 😗
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Views
I would throw out the idea that a view element does its one job very well, which is to show you the array of records that was discovered in the formula. So it is not just an array that you can count.…
- Fred
- 6 mths ago
- 1
- Get help
- Reported - view
Re: Need Constraints
The code would look like: a.a_Employees = b.Employees But with how you set it up, you can only have 1 employee per project, ever. You will need a M:M table between Projects and Employees if you want…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Ninox Timesheet template
If you look at the Options section of the DB, you will see there are scripts in the Trigger after open section. Here is the relevant section: if record(Admin,1).…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: I have a problem with the Ninox app on all my Macs
Have you emailed support?
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: I have a problem with the Ninox app on all my Macs
@David thanks, what about the app version.
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: I have a problem with the Ninox app on all my Macs
what version of the app are you running? what version of MacOS?
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Comparing a formula field value with a string from within another formula field
Try putting text() around Status? What is the code for Status? Or in a test formula field create an if statement for Status to see what happens: if Status = "NOT PAID" then 1 else 0 end
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: freeze data in a field
@Rob have you tried a field level trigger? so when you select the product it copies the name, productID, and cost of the product into static fields. then you could have a button that you can click to…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: freeze data in a field
@Rob said: I want Ninox to be a printing calculator I'm not sure what that means. Are you creating a new record in a table every time you change values?…
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: Impression champs sur une ligne
@Alain Can you duplicate the DB and erase all confidential data? I need to see the structure and the table/field names.
- Fred
- 6 mths ago
- Get help
- Reported - view
Re: change single items of an array
Hi @Elena Rodriguez How about something like: let array1 := ["a", "b", "c"]; let changeItem := 2; for i in array1 do if index(array1, i) = changeItem - 1 then "f" else i end end the result is a,f,…
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Impression champs sur une ligne
@Alain Can you upload a copy of your database? Not just screenshots? None of the pictures show the relationship field Proposition111 or Propostition222.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Impression champs sur une ligne
Does your other table have the same relationship fields? Can you post a sample DB?
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Why is there no way to log-in to the Ninox Forum?
I've seen this before and what worked for me is to clear your browser cache of anything Ninox. Or try it in a different browser.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Relationship to and from question.
@Mr. K. If it works then that it all you need. If you change you mind and want some help troubleshooting, we are ready to help.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Lagerbestand
Can you post a sample DB? Actions like this are much easier to do if you are using Pages which allows you to take complete control of how people enter in data.
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Relationship to and from question.
@Mr. K. Sure. If you build out the Page you can hide all of the tables. 🙂
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Help with relationship
@Nicholas Daniel When you get a moment, please mark the post answered. :)
- Fred
- 7 mths ago
- 1
- Get help
- Reported - view
Re: Relationship to and from question.
Yes, please do show me a Page example. Thanks Ok, here it is. It is very basic. It does check to make sure you don't add similar places to the same campground.
Attachment
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Display data in dynamic choice
Do you have a formula field that separates year and month from the date field? Something like where you create two formula fields called auditYear and auditMonth.…
- Fred
- 7 mths ago
- Get help
- Reported - view
Re: Relationship to and from question.
@Mr. K. That is correct. You have to have a campground record before you can add a NearBy place, since NearBy is a child of Campgrounds. Or you can make a Page that does the work for you.…
- Fred
- 7 mths ago
- Get help
- Reported - view

1 5 6 7 8 9 156

Welcome to the Ninox community

Fred

Re: Group by equivalent

Re: Impression de plusieurs champs sur une ligne

Re: Impression de plusieurs champs sur une ligne

Re: Views

Re: Views

Re: Need Constraints

Re: Ninox Timesheet template

Re: I have a problem with the Ninox app on all my Macs

Re: I have a problem with the Ninox app on all my Macs

Re: I have a problem with the Ninox app on all my Macs

Re: Comparing a formula field value with a string from within another formula field

Re: freeze data in a field

Re: freeze data in a field

Re: Impression champs sur une ligne

Re: change single items of an array

Re: Impression champs sur une ligne

Re: Impression champs sur une ligne

Re: Why is there no way to log-in to the Ninox Forum?

Re: Relationship to and from question.

Re: Lagerbestand

Re: Relationship to and from question.

Re: Help with relationship

Re: Relationship to and from question.

Re: Display data in dynamic choice

Re: Relationship to and from question.

Overview