Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Is there a way to transfer multiple fields from one table to another?
To permanently move data from one table to another as a one time task, the best way, I think, is to use the Update multiple records function. First you need data in your new table can match the…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Neither of the two formulas work
@Rafael I don't use charts so I don't know if you can. Maybe someone with more Ninox chart experience can jump in.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
About your date issue. Looking at your sample CSV you sent in another topic, the date format of 4/12/22 is not liked by Ninox. Playing around it seems like Ninox is ok with yy-mm-dd with month being…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Looking at the fields, you are formatting the number fields in Ninox. If you edit Total2: you will see that there is formatting applied under Number format.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Something is not making sense. Can you upload this DB?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
Hi Mike - Can you give us an example the results of the found set? For example if I'm in the Flare Gymbol 3 record in the Actions table, what records should I see if the view element has the proper…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do i get my numbers $ to format right?
Total: is a number field? Are you formatting Total: in Ninox? Are you adding the $ in Ninox or did it import that way? You said you CSV has $ in front of the number,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: contact with many companies
Sounds like you need a third table, maybe called AssociatedCompanies. You would add two reference fields, one to Contacts and one to Companies. Then you would modify the Contacts reference field to…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Date of Birth? manually entry
I don't use the mobile apps too much, so I don't have much experience with it. On the Mac app, I can enter in date date directly into the date fields I have.…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: acces to array items like with Where fonction
I'm obviously not getting the logic behind all this so I'm putting this out there. Here is my code: let xH1 := allhito1; let xH2 := allhito2; xH1[var ah1 := this;…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
Thanks for figuring it out. It is not good that the two products don't function the same.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Date of Birth? manually entry
While the calendar pops up, you can still type in the box to enter in the date desired. Just be aware that it is picky about how you enter data. On my English US system, I can not type in:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Complex Select statement for View
I too use the app. Exit your DB but not the app. You will see a list of all your DBs. Then follow my previous instructions. Sadly exporting a CSV will not help us.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Just sent an email to Ninox.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: How do i get my numbers $ to format right?
To confirm, all your fields in the picture are text fields? Since your data from your CSV has $ in it, Ninox will treat any data with non numbers as text.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
I put the ( ) in but everytime I save it and go back in Ninox strips them out. That is so weird that it is not working for me. I've even try the for loop and that also gives me a blank field.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Complex Select statement for View
I to am intrigued by your question. To save a copy, at the start of the program with the DB list, if you click on the down arrow on the top right corner of the DB,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
@John Halls said: x[=v], v doesn't have to be a single element, and can in fact be larger than x If I'm learning the concepts correctly, I'm sure people smarter than me will correct me,…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: acces to array items like with Where fonction
Sadly that gives me a blank result: let array1 := [1, 2, 3, 4, 5]; let x := [1, 3]; array1[var v := this; not x[= v]]
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Related table field reference
take a look at the category field in Purchases. If I remember correctly I used the record command.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Ok, so I'm trying to remove one array from another. let array1 := [1, 2, 3, 4, 5]; let x := [3, 1]; array1[this != x] Doesn't return 2,4,5 If x = 3 (a single digit) then it works).…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Neither of the two formulas work
To do a series of dates you need the for loop command. Which means you need an array of the dates you want to create records for. One way is to create the array in the formula.…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Related table field reference
I've made a few changes you can check out. @Gianluca said: I need to sum all the purchases made by a person, grouped by a "category" specified in the "Catalogue" table (in this sample: guitars,…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Neither of the two formulas work
You have to remember that select statements always return an array. So for the first one you need to do a few things: let xDoc := first(select 'DOCUMENTOS'); let xFld1 := xDoc.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Date function
Yes, this whole "no code" advertising is very mis-leading. You can use the format function: format(datefield,"D MMM") Here is a list of formats available.
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 122 123 124 125 126 153

Welcome to the Ninox community

Fred

Re: Is there a way to transfer multiple fields from one table to another?

Re: Neither of the two formulas work

Re: How do i get my numbers $ to format right?

Re: How do i get my numbers $ to format right?

Re: How do i get my numbers $ to format right?

Re: Complex Select statement for View

Re: How do i get my numbers $ to format right?

Re: contact with many companies

Re: Date of Birth? manually entry

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Date of Birth? manually entry

Re: Complex Select statement for View

Re: acces to array items like with Where fonction

Re: How do i get my numbers $ to format right?

Re: acces to array items like with Where fonction

Re: Complex Select statement for View

Re: acces to array items like with Where fonction

Re: acces to array items like with Where fonction

Re: Related table field reference

Re: acces to array items like with Where fonction

Re: Neither of the two formulas work

Re: Related table field reference

Re: Neither of the two formulas work

Re: Date function

Overview