Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3527
551
4

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

My Posts

Latest Posts

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
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

1 79 80 81 82 83 142

Back to top

Overview

View all topics