Fred

San Francisco, USA

3610
568
5

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

My Posts

Latest Posts

Re: 3.12 webinar link
@Alan Cooke I never hold my breath for anything Ninox does. It allows me to be "pleasantly" surprised.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: The problem of writing N:1 code.
I'm guessing that copy is the N and HOME is the 1? How do you want to handle when you have multiple records in copy that is linked to 1 HOME. This is the big question.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: 3.12 webinar link
I guess now we wait for the repost on YouTube.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
Looks like in 3.12, there will be the ability to export to excel through code, createXLSX().
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Export file excel in a subtable.
@Nguyen Nhat Dong I don’t think so. There is no way that I know to set the filter of a table view column. You might want to consider using a view element.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
these error icons on your tables/pages is a start to your troubleshooting. Then when you open the table you will see Table2 also in red.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
After poking around it looks like there is a reference field in two tables and a Page ('What is a page', writtenbiz, and TODO) that is broken and can not be deleted.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Error: Type not found: I when printing
@john cesta wow. They use to do email support for all customers. I just checked and now basic does not provide any support at all. you can try Nioxus, but there will be a fee.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying Data in View by Dates
@Terry Prokopchuk said: I would like to further filter the dataset. Ok, then you have it setup quite well to add another switch. You currently have Switch1 and Switch2.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong what did Ninox say is the solution?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong you don’t have to change all today(). Just ones that you find issues with.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong I think the bug is in the server not able to convert Date into local time when comparing to today() on the client.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying Data in View by Dates
@Terry Prokopchuk said: however, I am now looking to sort the data further also by allowing the user to sort further by category When you say "sort" are you talking about filtering the found dataset…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Fred said: Thanks, I'm going to try it after 4pm PST as I am also in PST. Well I was able to duplicate the issue. I thought they fixed date issues like this when they made DBs Timezone independent.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong Thanks, I'm going to try it after 4pm PST as I am also in PST.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong which time zone?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
@Nguyen Nhat Dong you said you are in San Diego? are you using the app or cloud? If the app which version?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying Data in View by Dates
@Terry Prokopchuk If you edit a field, then click on More options you will see a field called Binding. Change it to Per record in memory (browser). That way the selections made by users will not be…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying Data in View by Dates
oops forgot the default case: let getUserTasks := select Tasks where 'Allocated to' = user(); switch 'User Task Choice' do case 1: getUserTasks['Due Date' = today())] case 2:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Displaying Data in View by Dates
You can try the following changes: let getUserTasks := select Tasks where 'Allocated to' = user(); switch 'User Task Choice' do case 1: getUserTasks['Due Date' = today())] case 2:…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: HTML Responsive Grid-Container + Custom Buttons
Learning something new today. I like the idea of grids in CSS. I found this website: So playing around I found this code is close to what you want. let term := (select Appointments where Status = 1);…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@我是我的我 Please share your solution.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Interesting HTML formatting
@MZ I missed that. Also you could remove the second select in line 2: let table := ((select DummyTab) order by -DATUM); let filterTable := ((table[PREIS > 11]) order by -DATUM);…
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Could you please help me identify the issue?
@我是我的我 Yeah, it doesn't work in your DB. Weird. I was able to take the code from@MZ and put it in a DB of mine and it works fine. In your DB, I: 1) created a new Page 2) created a new formula field…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Interesting HTML formatting
@MZ Love it. Very interesting that you can create variables for thead, tbody, tfoot and then put it all together later. I'm not sure what is the purpose of the first table variable on line 1.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view

1 39 40 41 42 43 145

Welcome to the Ninox community

Fred

My Posts

Re: 3.12 webinar link

Re: The problem of writing N:1 code.

Re: 3.12 webinar link

Re: Export file excel in a subtable.

Re: Export file excel in a subtable.

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Re: Error: Type not found: I when printing

Re: Displaying Data in View by Dates

Re: How to auto create new record every day?

Re: How to auto create new record every day?

Re: How to auto create new record every day?

Re: Displaying Data in View by Dates

Re: How to auto create new record every day?

Re: How to auto create new record every day?

Re: How to auto create new record every day?

Re: How to auto create new record every day?

Re: Displaying Data in View by Dates

Re: Displaying Data in View by Dates

Re: Displaying Data in View by Dates

Re: HTML Responsive Grid-Container + Custom Buttons

Re: Interesting HTML formatting

Re: Interesting HTML formatting

Re: Could you please help me identify the issue?

Re: Interesting HTML formatting

Overview