Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

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
Re: How to count days
That helps a lot. So let us start small. If we want to find all records where field Type = 1 (or "Calls") in the History table then figure out how many days elapsed between the earliest date and the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to set a value for a switch elements
Hi Heidi - Can you be a bit more specific? Since a switch is based on the value in a field and if the field is NOT a formula field you can put something like this in the formula section of a button:…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How to count days
You will need to use the days functions. days(datefield1, datefield2)
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Script: Test for 'if this is true and that is true, then..."
your logic is correct, to extend the search you just add "and". Can you post the exact code you are using and why it is not working?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Retrieving a deleted record made by mistake
Only if you made a backup of the DB.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Spam spam spam span spam egg and chips
Hi Mel - I use to send an email everytime there was spam then I got my hand slapped by their Support team for doing that. And the forums are just the same as they are.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trouble with two table references - same settings, different results.
Oh, Davie. You have now experienced another pain point for Ninox users, the Manual or lack of one.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Spam spam spam span spam egg and chips
Sadly Ninox has shown that it doesn't really care. Many of us have complained. Many have gotten responses that they are working on it. And years later we have a new generation of users experiencing…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort properly - 12 is less than 2. I don't think so!
"but if an application was to look at a string and see Letter, Letter, Number, Number could it not decide to treat two numbers as a single number and sort acordingly?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Advice wanted for database design (modelling?)
The question of do you need a separate task table will depend on the data being kept. Are you doing the same task to every photo? Could you be adding more tasks in the future?…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 124 125 126 127 128 145

Welcome to the Ninox community

Fred

My Posts

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

Re: How to count days

Re: How to set a value for a switch elements

Re: How to count days

Re: Script: Test for 'if this is true and that is true, then..."

Re: Retrieving a deleted record made by mistake

Re: Spam spam spam span spam egg and chips

Re: Trouble with two table references - same settings, different results.

Re: Spam spam spam span spam egg and chips

Re: Sort properly - 12 is less than 2. I don't think so!

Re: Advice wanted for database design (modelling?)

Overview