Fred

San Francisco, USA

3693
590
5

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

My Posts

Latest Posts

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
Re: Trying to "hide" records in main table
Just wondering, did you create the same field and field names in the Received table? The second post code doesn't work cause you have a semicolon after newReceived thus ending the line.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
Hi Hardy - A button is a "layout element". If you go to Edit Fields you will see on the right side Add layout element. From there you can add a button. When you double click on the button field you…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trying to "hide" records in main table
There is no "Move" command so you will have to hard code the copying of data field by field from the Orders table to the Received table. There will also be many steps to get to your desired results…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Query
Do you want this 3rd table to be a "dashboard" that you can use view info from other tables? You can view this video for the basics on how to create a dashboard: https://www.youtube.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
Hi John - Going off the data in your picture, 1 day would be the appropriate result for the days command as there are 3 records with Type = Call and the earliest date is 17/01/2022 and the latest…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Query
Are you talking about creating a third table? or adding a view element to an existing table? If the field Nr is a reference field in User to Contractor,…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 127 128 129 130 131 148

Welcome to the Ninox community

Fred

My Posts

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

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: Query

Re: How to count days

Re: Query

Overview