Fred

San Francisco, USA

3692
590
5

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

My Posts

Latest Posts

Re: I can't sum just one month on column, i need sum month by month expenses
Again, I have led you down the wrong path. Sorry for not catching this earlier. Please see the corrected code below: sum('4_Suppliers'.'Order with supplier'['Order date' >= date(2021,03,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: My actual plan is not available anymore but i can't do the uploading
Things pertaining to Ninox plans are best handled by Ninox themselves at support@ninox.com. Ninox is rarely on the forums.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: I can't sum just one month on column, i need sum month by month expenses
Well then the next step is for us to get a better understanding of your structure. I'm guessing that '4_Suppliers' is a reference field in whatever table you are working in.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: I can't sum just one month on column, i need sum month by month expenses
Hi Julian - If you want to do in between two dates then it should look like: sum('4_Suppliers'['Order with supplier'.'Order date' >= 2021-03-01 and 'Order with supplier'.'Order date' <= 2021-03-31].…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Update not triggering
Interesting that same code works in Trigger on Create and in a button but doesn't work on Trigger on Update.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Trigger on Update not triggering
Can we see the code you use in the Trigger?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hosed table
How do other DB apps handle deletion of fields? Do they tell you all the formulas that the field is apart of before you delete the field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Hosed table
How do other DB apps handle deletion of fields? Do they tell you all the formulas that the field is apart of before you delete the field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Setting up a FIFO inventory
Hi Yannick - I'm not sure I understand everything you ask, but I can help with bits. If the Articles table already have a reference field to Inventory and you are in Inventory wanting to see the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Triggers
Hi Hill Top Tire - Try something like: 'Cost Per Unit' := Article.'Purchase Price Per Unit'; 'Price Per Unit' := Article.'Selling Price' The semi-colon is the code to end the function.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy field contents into another linked tables field
Hi David - I would say you can do buttons if you can do Trigger after update. In fact I recommend always testing out functions in a button before putting them in triggers so you can control when they…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Using Table as Dropdown Menu items
Hi Appointments - You would use either the Dynamic Choice or Dynamic Multiple Choice. Then in Dynamic values you would put something like: select TableName Then in Dynamic value name you would put…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) for the groups of Contacts
Hi John - I've seen your question elsewhere about dynamic choice and printing. I am sorry to say I am not the person to talk to about it since I do not print anything.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) for the groups of Contacts
I would say that sometimes you don't need to link tables, like you suggested. For me I have a sports db and use to create a choice field everytime I needed to track year or season.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Move my local Ninox database to Ninox cloud
Hi - It is pretty simple. On your Mac, select the down pointing triangle in the upper right corner of your db to be moved. Select Save archive as... Put it somewhere you will remember Then log into…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) for the groups of Contacts
Hi Eric - Dynamic Choice fields currently look to tables for their values. Each record in the table represents a value in the dynamic choice field. I'm sure you have already tried it,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Est il possible de récupérer les x caractères de gauche de la valeur d'un champ ?
if the project number is a standard length: subtr(Fichier,7) if the project number is not standard length: let x := (Fischier,"_"); substring(Fischier, 0, x) I hope Google translates does an ok job.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice misbehaviour
I would say to contact support. I'm interested in what they say.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice misbehaviour
Did you happen to have made a change to the 3 record DC? I know on the MacApp version (3.5x) they have a bug where in table view formulas don't update automatically.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic choice fields in prints/pdf fx field
What is your code in the formula field?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Choice (dynamic) as view filter
Hi Kevin - You ask for access to the Webinar EN 2021 team by emailing support@ninox.com. I think your question will not be solved by a cascading DMC fields.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: transaction timestamp
https://ninox.com/en/manual/calculations/reference-of-functions-and-language scroll down, or do search for _md or _cd.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Using APP (IOS or ANDROID)
Seems like Ninox did not QA very well this time. There are a few Mac app issues as well.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Number formatting
Try lpad: https://docs.ninox.com/en/script/functions/lpad
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Many to Many Relatonships
Hi Alan - I'm guessing you are trying to use a combo box. If you leave it as a pop up then you can see all of the records. The advantage of a pop up is you can also quickly filter the list by typing…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 130 131 132 133 134 148

Welcome to the Ninox community

Fred

My Posts

Re: I can't sum just one month on column, i need sum month by month expenses

Re: My actual plan is not available anymore but i can't do the uploading

Re: I can't sum just one month on column, i need sum month by month expenses

Re: I can't sum just one month on column, i need sum month by month expenses

Re: Trigger on Update not triggering

Re: Trigger on Update not triggering

Re: Hosed table

Re: Hosed table

Re: Setting up a FIFO inventory

Re: Triggers

Re: Copy field contents into another linked tables field

Re: Using Table as Dropdown Menu items

Re: Choice (dynamic) for the groups of Contacts

Re: Choice (dynamic) for the groups of Contacts

Re: Move my local Ninox database to Ninox cloud

Re: Choice (dynamic) for the groups of Contacts

Re: Est il possible de récupérer les x caractères de gauche de la valeur d'un champ ?

Re: Dynamic Choice misbehaviour

Re: Dynamic Choice misbehaviour

Re: Dynamic choice fields in prints/pdf fx field

Re: Choice (dynamic) as view filter

Re: transaction timestamp

Re: Using APP (IOS or ANDROID)

Re: Number formatting

Re: Many to Many Relatonships

Overview