Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice misbehaviour
I would say to contact support. I'm interested in what they say.
- Fred
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Dynamic choice fields in prints/pdf fx field
What is your code in the formula field?
- Fred
- 4 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
- 4 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
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Number formatting
Try lpad: https://docs.ninox.com/en/script/functions/lpad
- Fred
- 4 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
- 4 yrs ago
- Get help
- Reported - view
Re: Airtable Convert - Looking For Feedback...
Tempting to create an independent forum, but I worry that people won't find it.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How do I create a new database using the custom tables created by me in another database?
Sadly there is no way to move tables between DBs. 1) You will have to manually recreate the tables or 2) Duplicate an empty testbed DB and then import the data from production
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Showing top performers based on linked records
Just to verify that the following is true: Participants table has a reference field to Coaches. Since your View element formula has select Coaches.Participants.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Airtable Convert - Looking For Feedback...
Ninox has been promising a new forum for now over two years. It will be right up there with a Win app.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Spam
:)
- Fred
- 4 yrs ago
- Get help
- Reported - view
Spam

Hang in there folks. Keep asking your questions. Ninox will hopefully clear out the spam. Eventually.
- Fred
- 4 yrs ago
- 2replies
- 142
- Get help
Re: Copy Table Reference Data to a different table
Glad I could help. I can't tell you how many times I've "redone" my DB as I've learned things.
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: How to. Products with variable options
Hi Brendon - Sounds like you will need a third table. It can be called Invoice, or whatever makes sense to you. Then you would create a reference field to product and customer.…
- Fred
- 4 yrs ago
- Get help
- Reported - view
Re: Copy Table Reference Data to a different table
Hi Jess - I think I can help. I'm guessing that the reference field in Active Orders and Ready to Ship is called Customer, so to link the record in Ready to Ship to the same Customer that was in…
- Fred
- 4 yrs ago
- Get help
- Reported - view

1 135 136 137 138 139 153

Welcome to the Ninox community

Fred

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

Re: Airtable Convert - Looking For Feedback...

Re: How do I create a new database using the custom tables created by me in another database?

Re: Showing top performers based on linked records

Re: Airtable Convert - Looking For Feedback...

Re: Spam

Spam

Re: Copy Table Reference Data to a different table

Re: How to. Products with variable options

Re: Copy Table Reference Data to a different table

Overview