Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

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
- 47
- 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
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view
Re: Calender language changed with newest update
Check out this post. Looks like you need to email support to let them know.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
You wrote: let xxx := length((select copy).name); for i from 0 to xxx do if i = 0 then 1 else 0 end end Here are the steps I suggested: 1) create an array of all records that have "coffee" in a the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 said: I would also like to write a piece of code in the copy table such that if "coffee" appears 3 times, the first occurrence of "coffee" is marked as 1, and the other two are marked as 0.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Professional help
Ninox has a partners search: https://ninox.com/en/find-partner We here in the forum are always willing to answer questions.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Birding database
@SimonS If you had the table of species then you can do a simple count() or length() of the table. Or you can modify the html code I posted earlier and add a few lines to get a count of species:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Whether the data content of table1 field can become the field of select(table2)
shucks,@John Halls beat me to it. Let us breakdown your code: let t := this; let X := 'code name'; first((select Table2)[name = t.name].X) According to your first picture,…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Display associated content with conditional constraints.
@我是我的我 can you post your solution so others can learn from your wisdom?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Birding database
to be helpful like,@Sotirios Zormpas , here is a sample html. Put the following into a formula field. let getSightings := (select 'Sightings revised 1'); let uniqueSpecies :…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Birding database
@SimonS said: Not quite sure how to do that. I’ve attached an archived version. that will work. so you have this in your view element: select 'Sightings revised 1' where unique(Species) Sadly,…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view

1 41 42 43 44 45 150

Welcome to the Ninox community

Fred

My Posts

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.

Re: Calender language changed with newest update

Re: Display associated content with conditional constraints.

Re: Display associated content with conditional constraints.

Re: Professional help

Re: Birding database

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

Re: Display associated content with conditional constraints.

Re: Birding database

Re: Birding database

Overview