Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3632
576
5

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

My Posts

Latest Posts

Re: Hide button if selection in Multiple Choice
Just to be clear, are you talking about a regular multiple choice for a dynamic multiple choice?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: In the "Items" table there can only be one "Stock" field, not three. In short, the "Stock" field should be replaced by "Real Stock", Yes that is true.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: 3.8
@Mel Charles i’m not sure. every version throws me into a tizzy. plus, do people fell this “version” was worth a 0.x?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
Looking at the flow again. I changed: Removed the code to add the data from Achats Enregistrer button. Created a new code for Commandes Fournisseurs.Status Achat trigger after update so when you…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: 3.8
v3.8.4 is now live in the cloud.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
So try out the following work flow: 1) create a new purchase from a supplier and add a few items that currently don't have any stock. 2) you should see the Stock_current field get updated.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
Ok, I've modified the (NINOX TEST) db with the following: Article table: Stock_current - number field Listes table: préInventaire - number field inventaireFinal - formula field with 'préInventaire' +…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
Never mind. My mistake. I fixed it.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
where is the code that sets the Status in Inventaires to 3? I can’t find it.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: Thank you for your intervention, but the stock of items "Articles" does not change once the inventory has been validated You have to decide how you want Articles.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: locking all records help please
You can try: for i in (select 'DOCUMENT REPOSITORY')[LOCKED = true or LOCKED = null] do
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: On the other hand, do not hesitate to set up your solution in the SoundProcess(Testing) database. Ok, I've modified the SoundProcess (NINOX TEST) DB.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
May I recommend a different way of approaching it. As you stated, an inventory needs to a snapshot of your stock at a particular date. Which means you need all the data in that table to be isolated…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Script for Inventory
@Didier Schoonjans said: The only thing left to do is for the "Frozen Stock" column to become a formula that extracts and FREEzes the stock. What do you mean by “FREEzes the stock”?
- Fred
- 2 yrs ago
- Get help
- Reported - view
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

1 83 84 85 86 87 146

Back to top

Overview

View all topics