Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: 3.8
Something needed to be fix quickly as now 3.8.4.1 is out. I don’t think I’ve seen that before.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Hide button if selection in Multiple Choice
@thomas said: But what if the name DAF FF 058 PS 2600 KG in the dmc, referenced to the table AUTOCARRO is composed using this formula Just treat it like a normal filter: let x :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Step-by-step onboarding available in German
Too bad my high school German was so long ago that it is not useful here. 😂 Look forward to the English version.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Hide button if selection in Multiple Choice
@thomas said: it's a dynamic multiple choice field then you can try something like: let x := for loop1 in numbers(dMCfield) do record(dMC-tableName,loop1) end;…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
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

1 90 91 92 93 94 153

Back to top

Overview

View all topics