Fred

San Francisco, USA

3418
539
4

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

My Posts

Latest Posts

Re: Highlighting entries in table A that are selected as reference link in other tables.
I guess you need to figure out a way to be able to enter in a contact and be sure it is not a duplicate. Let us know if you want to go down this path by starting a new post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Unable to Archive Databases on MacOS
I'm guessing you have email Ninox about it. Since it is a Sunday (so far in USA), let us know what Ninox says when you do hear back. In the mean time I will not be upgrading MacOS app.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: the problem is finding the trick to value the stock (and that's only where I'm stuck at the moment) I would then ask why Stock is a formula field?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Converting a text string to a multiple choice field
Maybe try out: let y := split('Request Ages', ","); let x := for loop1 in y do switch true do case loop1 = "1st Grade": 1 case loop1 = "2nd Grade": 2 case loop1 = "3rd Grade":…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Converting a text string to a multiple choice field
Luckily Ninox allows you to use an array to set multiple choice or dynamic multiple choice fields. So if you put something like this in a button: let x := [5,7]; 'Grade Level(s)' :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: t is necessary that the system keep a chronological trace for each case (purchases, sales, inventory and manufacturing) If this is necessary then you need to create tables…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: I would like the stock to live, keeping the history of all movements. Exactly like purchase orders and sales invoices. I was thinking that stock shouldn't live in Articles…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Calculate the most recent date of an activity
May I recommend the order by function. Which would sort your records by a field before picking the last one. So if ‘Rendez-vous’ is the date field: let x := last(Activities order by 'Rendez-vous') x.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: yes I understand the theory, but I do not see how to apply this in my case I created a new field called 'Real Stock' in the Articles table and put this in the formula:…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Warning of dynamic multi choice bug
Well I asked if this was fixed in 3.8 and was told to test it out. Huh? Anyways. Since I can't get a straight answer, I did a test and so far it looks like it is fixed.…
- Fred
- 2 yrs ago
- 1
- Learn and share
- Reported - view
Re: Problem reference between tables
May I suggest you create a third table called Event Staff. Then create a reference field to Events and Employees. You can add any other field that you need as well.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: 3.8
v3.8.3 is now up. I hope it is more stable for everyone. Wish they could give cloud users a way to wait until x.x.5 till they iron out all the bugs.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: 3.8
another day, another version, v3.8.2, is up. In case anyone is interested here is the release notes, for what they are worth. I'm sadden to see this: We fixed a bunch of bugs for this release—but we…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: So the theory would simply => Stock = Stock + Différence Ninox is correct that you can't use a circular reference. Stock is a formula.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Dynamic choice from Multiple choice field
@Marisol Echaide said: Say Customer A has registered two VAT regimes: Margin Scheme and Local VAT in a multiple choice field within the Customer table. Your multiple choice field is a regular…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Locking Records in multiple tables from one
This would be an easier way, if you wanted the child records to always be in sync with the parent. But if need the ability to micro manage the lock state of each child record then your current method…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Locking Records in multiple tables from one
It looks like the script UNLOCKS, but maybe you have it the other way around. Using your provided code, you can try something like: for i in (select PROJECTS)[LOCKED = true] do i.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Programming language for Ninox
here are some free videos.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Programming language for Ninox
check out this post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Enter the content of another field inside a rich text field
@RoSoft_Steven Thanks for the tip of the raw() command to transfer Rich Text formatted text into html().
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Creating a new record in a linked table using code
@spinner. 7580 said: I wanted to pull out Route_ID to display the full route description in a formula field based on the choice in Route_X, that way I can confirm that I picked the correct route…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Cannot create more Forms!! - Cloud version
A Ninox hiccup? I was able to create a new view on the Cloud version.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Enter the content of another field inside a rich text field
There are smarter people who can answer this better, but there is an example of what you can do: let xFName := Volunteer.FName; let xLName := Volunteer.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
Here is a quick and dirty method of taking into account "," in names: let CRTN := " "; let x := for loop1 in numbers(dMC) do let y := record(Cities,loop1).…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Display multiple dynamic choice items separated by returns rather than commas in Print
@tjdegrood Yes, I did not take that into account. If I come up with a programmatic way I'll let you know.
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 75 76 77 78 79 137

Welcome to the Ninox community

Fred

My Posts

Re: Highlighting entries in table A that are selected as reference link in other tables.

Re: Unable to Archive Databases on MacOS

Re: Script for Inventory

Re: Converting a text string to a multiple choice field

Re: Converting a text string to a multiple choice field

Re: Script for Inventory

Re: Script for Inventory

Re: Calculate the most recent date of an activity

Re: Script for Inventory

Re: Warning of dynamic multi choice bug

Re: Problem reference between tables

Re: 3.8

Re: 3.8

Re: Script for Inventory

Re: Dynamic choice from Multiple choice field

Re: Locking Records in multiple tables from one

Re: Locking Records in multiple tables from one

Re: Programming language for Ninox

Re: Programming language for Ninox

Re: Enter the content of another field inside a rich text field

Re: Creating a new record in a linked table using code

Re: Cannot create more Forms!! - Cloud version

Re: Enter the content of another field inside a rich text field

Re: Display multiple dynamic choice items separated by returns rather than commas in Print

Re: Display multiple dynamic choice items separated by returns rather than commas in Print

Overview