Fred

San Francisco, USA

3614
570
5

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

My Posts

Latest Posts

Re: How can I structure the extraction of inventory data?
@我是我的我 The second method is also quite doable. I am not talking about copying each record from the two tables, but a summary of the data from the two tables.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How can I structure the extraction of inventory data?
Can you merge the two tables together? It seems like the data would be exactly the same except for one or two fields. Otherwise you would have to create a button that would copy the data you want…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Scaling up - multiple users
One option is to use a website or google form that then uses some middle-ware like Zapier or Make to then make the changes to Ninox.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Why is there no response?
@我是我的我 said: What's even stranger is that the same code works fine in the database in the Public Cloud, but no data is returned offline). I'm not sure what you mean by this.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Why is there no response?
Looking at 1 and 2 you don't need the contains() command. Since each record in "copy here" has only 1 value for name you can do a simple equal. let s := this; select 'copy here' where name = text(s.…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Pop-up field showing wrong columns
It is not a bug. Just not intuitive. I haven't played around with reference field Show Field As and I notice that fields now change depending on the type selected.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael said: hi Fred Now this is my Code. But the problem in this example, I should only appear year 2024 but appear 2023 too. Ok, well looking at your code closer (which I didn't do very well…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael The code looks ok to me so I don't know why you are getting records that seem to fall out side the filter. Can you upload a sample DB with no personal info?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: I have two questions about HTML code.
For the 2nd question, you are correct your code can become very long if you repeat the table as well in your conditional statements. You can put your conditional statements inside the <style> part of…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)
@Rafael what does your version of the code look like? I would also switch the now() to today() since you don’t need the time data that now() has.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to calculate the number of days in this year or next year?
@我是我的我 Do you want to know the number of days left in the year from today? You can try something like: days(today(), date(2024, 12, 31)) If you don't want to hard code ending date then you can create…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to calculate the number of days in this year or next year?
Can you be more specific?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Rafael add “order by JSONfieldname” at the end of your JSON, after the closing curly bracket.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: getting started
email Ninox support directly.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Rafael can you show your JSON code and your word doc so others can see what you did?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Rafael carbone does not like spaces in names. Please see my previous comments about using JSON and Ninox's recommendation in this post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
@Alan Cooke said: Where/how do I use the JSON? This will be a first for me. Under Test Print there is a switch for Custom JSON, flip it on. Then click on the Fx button.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic Reports
I think you need to put the [i] after d. {d[i].SYSTEM} Then the 2nd line would be: {d[i+1].SYSTEM} Since SYSTEM, CATEGORY, AND NOTES are fields in a record,…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Local, iCloud or Public Cloud ?
First time I've heard this asked. I've never come across any function to do that, but then that doens't mean it can't be done.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: duplicate bug?
You are correct. The record gets created but Ninox does not take you to the new record. I am also running 3.11.4. This does NOT happen for public cloud DBs in the app or in the browser.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: loop in query for view -- how to aggregate?
So you want to end up with records in Benefices where the entry equals the entries of the current record? Wouldn't this work? let my_event := this; let my_entries := unique(this.'is testified by'.…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Retrieve the data from a button variable
@Sébastien Guillet I think I get it. You can't access information in a button. Your button writes to the field 'text_birthday' you can access data in that field.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Retrieve the data from a button variable
@Sébastien Guillet Try: from: loop1.Entreprise.'E-mail', to: loop1.'E-mail principal', subject: "Happy birthday", text: "Bonjour" + if loop1.'Prénom' then " " + loop1.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Retrieve the data from a button variable
Or you could put the code from the button that generates the text into your loop.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Generated an array with record numbers in a formula field.
Take the base of the Total Time formula field and make a change to line 3. let t := this; let cc := record(clientchoicetablename,number('Client Choice')); cc.'Booking Time'[Date = t.date].…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 48 49 50 51 52 145

Welcome to the Ninox community

Fred

My Posts

Re: How can I structure the extraction of inventory data?

Re: How can I structure the extraction of inventory data?

Re: Scaling up - multiple users

Re: Why is there no response?

Re: Why is there no response?

Re: Pop-up field showing wrong columns

Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Re: I have two questions about HTML code.

Re: Find in View (Today, Last Week 5 days, Last Month, Last Six Month and Year.)

Re: How to use code to calculate the number of days in this year or next year?

Re: How to use code to calculate the number of days in this year or next year?

Re: Dynamic Reports

Re: getting started

Re: Dynamic Reports

Re: Dynamic Reports

Re: Dynamic Reports

Re: Dynamic Reports

Re: Local, iCloud or Public Cloud ?

Re: duplicate bug?

Re: loop in query for view -- how to aggregate?

Re: Retrieve the data from a button variable

Re: Retrieve the data from a button variable

Re: Retrieve the data from a button variable

Re: Generated an array with record numbers in a formula field.

Overview