Fred

San Francisco, USA

3424
540
4

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

My Posts

Latest Posts

Re: How do I join two different conditions in one statement (and/or) thank you
in a if statement: if field1 > 10 or field2 < 20 then ... in a select statement select Table1 where field1 = null and field 2 = "Bad" or select Table1 [field1 = null and field 2 = "Bad"]
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Somewhere to share user templates?
You should email support@ninox.com. The ninox team does not post much on the forums anymore.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: how do I delete values from a choice field
Sounds lik you are using iCloud storage. If that true then only 1 device can "own" the DB and thus edit the structure. If you want to change ownership then you have to make sure the db is closed on…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.
Hi Louis - Sorry, you said you want the data copied. So you can put something like this in a button in Table1 to test it out: let x := record('Table 2',number(Response));mitigation := x.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.
Hi Louis - Do you want the data from Table2-mitigation copied to Table1-mitigation? or Do you just need to see what the data is in Table2-mitigation when you select a Response?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Select last child record
Alain brings up a good point, Ninox does not like "a lot" of select statements. How much is "a lot", you won't know until your DB starts to take a long time to load a table.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Select last child record
Just saw the issue, you can't use 'this' in a search. So you would have to change to: let currentRec := this;<--assuming you are in the Composer tablelet xYear :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Select last child record
Question: What kind of field is 'ThisYear'?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to copy fields on create
There is a console but I've never used it so I can't give any help there. That said, when you create a new record in Client, a record Id is created, so that relationship can be linked.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to copy fields on create
Looks like you have answered your question. If the code in Trigger on New Record, you have not entered in any data for Ninox to copy. Try putting the code in Trigger after Update under the 'First…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem of links between two tables
Hi there - For future reference, you want to create the reference field in the table that will have many records to 1 record in another table. Since you want to be able to have 1 musician for many…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Hi Davie - I don't think I suggested you enter in data typical Y-M-D format. If you look at my comment all I said was to start any data entered with the year.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Ok, I think I get it now. From your answers you do want part of #1. You want to enter data in a field and for Ninox to then set data in another field which is a reference field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Selecting
Hi Henrik - Try changing the code to: last(tablename[type=2].date) You have to put the search parameter next to the table you are searching, not at the end.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Let me see if I understand the situation. Looking back at your first post: you have a form view in your Pages table where you enter in data. The form has the following fields:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Use a date to lookup a table to get a code
Hi Davie - I'm a bit confused on what you want to do. For you second post, something like this will get the appropriate code based on year: first((select Years [Year = year(Datefield)]).Code)
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula for calculate total of recurring expenses
Hi Guiseppe - Most things are possible. I'll give just one example. Here is what I've come up with: If we take our previous code and put it in a new field, which I call Exp2020,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Image copy from Child Table to Parent Table
I don't use images much so I don't have a deep understanding of how it works. So I don't know if question 1 can be done. Question 2, Ninox doesn't copy images (at least on the MacOS app) very well.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Formula for calculate total of recurring expenses
Hi Giuseppe - This is an interesting question. So I was able to create the following table. There are two scenarios, that come to mind, that you have to account for:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to Sort Localisation fields properly ?
Hi Julien - The sorting is normal text sorting. Computers sort text by sorting by the first character of a string, then the second, etc. So with the following text:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
You ask if you change 'Received by' to 1,2 or 3 will trigger the script. I'm guessing you have tested out each true scenario and a false (when 'Received by' = 4,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
are you putting the code we already worked on between the if and end?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
I forgot to answer your first question. "Would I need to put each script in the respective field under trigger after update?" I'm not sure what you mean by "each script".…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
Hi Hardy - Glad the button is working. What Mel suggest is still two steps away, I am breaking down the steps so you can understand what is going on. Plus it is always a good to test scripts like…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
what you wrote should work. i noticed that there is a space after "newReceived.". There shouldn't be any spaces. let curRec := this;let newReceived := (create Received);newReceived.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 116 117 118 119 120 137

Welcome to the Ninox community

Fred

My Posts

Re: How do I join two different conditions in one statement (and/or) thank you

Re: Somewhere to share user templates?

Re: how do I delete values from a choice field

Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.

Re: using the selection of dynamic choice fields to autofill a text field with data from the table used by the dynamic choice field.

Re: Select last child record

Re: Select last child record

Re: Select last child record

Re: How to copy fields on create

Re: How to copy fields on create

Re: Problem of links between two tables

Re: Use a date to lookup a table to get a code

Re: Use a date to lookup a table to get a code

Re: Selecting

Re: Use a date to lookup a table to get a code

Re: Use a date to lookup a table to get a code

Re: Formula for calculate total of recurring expenses

Re: Image copy from Child Table to Parent Table

Re: Formula for calculate total of recurring expenses

Re: How to Sort Localisation fields properly ?

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Re: Trying to "hide" records in main table

Overview