Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Issue/Bug in report creation
@Alan Cooke I hate to break it to you but Ninox's solution is their dynamic printing. Which is not available to local DB users. They will most likely not spend any effort fixing their old print…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Whether the data content of table1 field can become the field of select(table2)
@張良仲 With how you setup your DB, it is not simple. Did you try@John Halls DB? Did you modify your DB to use a N:N table? Your code should work as long as A, B, C,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Formula for button to copy table
I tested in the app with a cloud and local DB and was not able to reproduce it. Can you upload a sample DB?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
You don't mention if you have previous relational DB experience. If you come from the spreadsheet world, I would say that understanding and getting comfortable with relationships is very important.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: New Member Introduction - Seeking Guidance and Tips
Welcome Mitchel. You can get help here in the forums. There is an official Ninox FB page, but support is provided by other users. If you have a Pro account with Ninox you can email them.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Need Script for transfer Dates
@Rafael remember you are now inside a for loop, so your me variable (which is linked to this) will link all of your record to this one record. You need to change your references from me to s.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Active processes in background
Sadly a starter can’t. You can email Support. They usually help with big stuff like this.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Script for transfer Dates
I did a test and found this works: newR.( 'Control Deliverables_>' := me; Name_Document := me.'Name Document'; 'Forecast 1' := me.'Real 1'; 'Real 1' := me.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Loop through Records
@stephenjtaft said: just to have the large freedom to add multiple granular permissions I guess we are thinking differently about what a permission is. My thinking was in terms of permissions to do…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: how to add to variables
@mark. robinson It is not that Ninox is not returning a number. It is, but if you don't use one of the array commands, then Ninox will return an array of numbers.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Loop through Records
to answer your question, I first need to tell you how multiple choice (regular or dynamic) fields work. Once you select a second choice, then Ninox will return an array of the choices.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: createXLSX: format column as currency
@Andy I just looked at video 130 and you only talk about making column G right justified. You don't mention anything about setting it to Currenty or Date with in createXLSX().
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: an you please help me optimize the code structure?
@我是我的我 It seems like all your cases are exclusive, but remember to put the case that will happen the least often at the top and the cases that happen the most often at the bottom.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: an you please help me optimize the code structure?
@我是我的我 with such a complicated set of ifs and switches you will need to start at the beginning and with a new formula field start with your first if then slowly add the switches and ifs one step at a…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Query Help - Count of records in joined table that meet X criteria
you can try: count('Staffing Gigs'[year('event date') = year(today())]) When you are filtering relationship fields you use the square brackets [ ]. You can also use the year() command to get the year…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Always have a backup in two different places

A worst case scenario happened. Luckily someone decided not to put all their eggs in one basket. Just a reminder to never trust one provider.
- Fred
- 1 yr ago
- 49
- 1
- Learn and share
Re: an you please help me optimize the code structure?
Let me see if I read you code properly: check if ZM = 0 and LM = 0 if true than show NO in an alert box. if false switch on field 'L&Z'. if the value of L&Z = 1 then check if ZM is less than the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I Need to update field in another table.
@Rafael Please answer my questions above so we can help you.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Odd behavior / bugs with PAGES on macOS
@BuffaloTony I switched over about two years ago. I noticed that the disparity started to grow and then they made the app free. Which means they can, not that they do, care about it less.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I Need to update field in another table.
@Rafael 1) does the select find the correct records? 2) if #1 is ok, then what is the issue going on?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I Need to update field in another table.
Since you said you want to update data, then you need to first put in a variable the correct record Id of the record in Control Deliverables. You can do a select or use appropriate reference links.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Odd behavior / bugs with PAGES on macOS
@BuffaloTony You can submit a feature request, as Nick did point out that Ninox does not say Pages is for the app with local DB. I wouldn't go holding my breath to ever hear from them.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Odd behavior / bugs with PAGES on macOS
@BuffaloTony Or you can click on the letter of your account name in the upper right corner of the app.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 Well, you have to decide how you want to deal with the 'and' part of your code: let aa := this; (select copy where 'Y&N' = aa.'Y&N' and fieldname = 1) order by -appearances In record 1 of Home,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: I don't know how to start because I haven't understood the purpose of the square brackets yet. Square brackets can be used in place of where in selects and to filter out any array.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 43 44 45 46 47 153

Welcome to the Ninox community

Fred

Re: Issue/Bug in report creation

Re: Whether the data content of table1 field can become the field of select(table2)

Re: Formula for button to copy table

Re: New Member Introduction - Seeking Guidance and Tips

Re: New Member Introduction - Seeking Guidance and Tips

Re: Need Script for transfer Dates

Re: Active processes in background

Re: Need Script for transfer Dates

Re: Loop through Records

Re: how to add to variables

Re: Loop through Records

Re: createXLSX: format column as currency

Re: an you please help me optimize the code structure?

Re: an you please help me optimize the code structure?

Re: Query Help - Count of records in joined table that meet X criteria

Re: an you please help me optimize the code structure?

Re: I Need to update field in another table.

Re: Odd behavior / bugs with PAGES on macOS

Re: I Need to update field in another table.

Re: I Need to update field in another table.

Re: Odd behavior / bugs with PAGES on macOS

Re: Odd behavior / bugs with PAGES on macOS

Re: Display associated content with conditional constraints.

Re: Display associated content with conditional constraints.

Overview