Fred

San Francisco, USA

3381
533
4

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

My Posts

Latest Posts

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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- 40
- 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths 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
- 8 mths ago
- Get help
- Reported - view
Re: Odd behavior / bugs with PAGES on macOS
@Nick You are correct, Nick. I forgot to test on local DB. I can confirm that Pages, does not work on local DBs.
- Fred
- 8 mths ago
- 1
- Get help
- Reported - view
Re: Odd behavior / bugs with PAGES on macOS
tested in v3.12.2 on my Mac and had no issues with images or dynamic choice fields.
- Fred
- 8 mths ago
- 1
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: Although these are too difficult for someone like me who doesn't understand code, It wasn't that difficult as you seem to have no problem figuring it out.…
- Fred
- 8 mths ago
- Get help
- Reported - view
Re: createXLSX: format column as currency
Well, according to Andy at Nioxus the Ninox docs for createXLXS() are not completely accurate. In addition he talked about a format function that is not defined in the docs as well.…
- Fred
- 8 mths ago
- Learn and share
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: For example, in the 'copy table,' 'beverage' is also considered a duplicate item. How can we achieve the same effect for these as well? That was the next step in the process.…
- Fred
- 8 mths ago
- Get help
- Reported - view

1 26 27 28 29 30 136

Welcome to the Ninox community

Fred

My Posts

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.

Re: Odd behavior / bugs with PAGES on macOS

Re: Odd behavior / bugs with PAGES on macOS

Re: Display associated content with conditional constraints.

Re: createXLSX: format column as currency

Re: Display associated content with conditional constraints.

Overview