Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3616
571
5

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

My Posts

Latest Posts

Re: Sum Based on Choice
@danlap333 said: 1) Statement Month is a simple choice field that I choose 2) Table name is "Receipt Details" 2) Table name that I want to get the totals from is "Receipt Details",…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Script problem.
@Rafael How did it work before since it using the same table reference. Just put the correct table name.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Sum Based on Choice
just to confirm: 1) Statement Month is a simple choice field or a dynamic choice field. 2) What is the table name of the screenshot? What is the table name that you want to get the totals from?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Script problem.
If you only want the last record then you don't need a for loop. You can try this modification: do as server let me := this; let i := last(select 'Task templates'); let new := (create Tasks); new.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: Below is what I've placed in, but now, it doest seem like anything is working... You are still putting in all the code. Let us make this a bit simpler.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Script problem.
@Rafael said: Is there some way to only copy the last or last one included, not all records. You only want to copy the last record in the Task Template table? Have you tried the last() command?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson The copy estimate button in the Job Status Log table doesn't do anything for me. Is that the right button. I click on it and when I paste nothing happens.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Ver 3.10 - new PAGES Feature
Another warning to users who use the app. Don't edit your pages in the app as it will turn it back into a table in the browser.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Ninext project
@Jacques TUR Sadly paste from another table does not just work in a Page. Nothing happens. If I go to a regular table it pastes fine. Copy within a Page or to another table doesn't work either.…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Ver 3.10 - new PAGES Feature
Since the apps are not updated to 3.10, I was wondering how a Page would show up in an app. Well, in MacOS v3.9.3, a Page shows up as a table. You can add records.…
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: I'm not sure what I'm getting wrong... below is all of my current code. When I 'click the button' (formula) and paste it, this is what I'm getting:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: v3.10 Enterprise only?
Well us public cloud users get Pages. But no modularity. :( Now I have to decide if I want to switch all my dashboards over to Pages?
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Copy to clipboard: Multi-line referenced table
@Taylor Hanson said: thank you! Any ideas about how to get things to order like this (with the paragraph returns)? Item Detail #1 ..........$Item Total #1 Item Detail #2 ..........…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HELP ME RANK PLEASE
@Rafael If they are equal then they should be ranked the same, no? How else would you rank them? You would need a 2nd field to use as a tie breaker.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HELP ME RANK PLEASE
You can put this in a button in any table: let myCount := 0; let getCars := (select TableA); for loop1 in getCars do let xScore := loop1.Score; let myCount := cnt(getCars[Score > xScore]); loop1.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Copy to clipboard: Multi-line referenced table
There are two ways to do a paragraph return/line break/carriage return. 1) just add a paragraph return: let outputList := ""; let details := 'Project Details'; for r in details do outputList :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Formula on Chart
@Rafael said: Yes I Have a Categories Tables. May I ask why you don't use it as the base for your dynamic field? It would mean you would probably want to change Gastos.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: HELP ME RANK PLEASE
Are you asking for code that you can put in a button that will rank the records for you?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Select records through Dynamic Multiple Choice Field
@Web Name said: The function I apply in the TabSearch.Fx field considers only Gamma and Iota clients and returns 300. It does not consider the Alfa customer because it belongs to multiple categories.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Need Formula on Chart
What kind of field is Categorias in Gastos? The way you created your Categorias dynamic multichoice field is an interesting way of doing it. The one thing I see is dynamic choice fields are based on…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Select records through Dynamic Multiple Choice Field
@Web Name said: In this last table, TabSearch, I would like to insert a formula that takes the largest customer turnover from the TabCustomers.Sales field between TabCustomers records that have the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Increase storage
If you are talking about cloud storage then you have to purchase another license. I know, weird, but that is how they do it. Email Ninox for information.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Yes/No function
@Marjolijn That is weird. If you look in the Coachees table, on the Sessies en Fracturn tab you will see a field called Sessies. This is the relationship view table created by Ninox from the…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Yes/No function
The answer to your second part is you forgot the ":" in front of the "=" sign for Afspraken, line 7. Easy thing to do in Ninox. To set fields to a value you use ":=".…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Yes/No function
I also tried cleaning up the code to: if OHW = false then date(last(Sessies.Sessie)) end And the same data is presented as with your code. let i := this; let s := (select Sessies); let n := Sessies.…
- Fred
- 1 yr ago
- Get help
- Reported - view

1 63 64 65 66 67 145

Back to top

Overview

View all topics