Fred

San Francisco, USA

3379
533
4

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

My Posts

Latest Posts

Re: Retrieve a field from one table in another
@giuseppe said: I can in the table “processing” retrieve data from the table “contracts” If you want to get delivery date in contracts from processing then something like the following in a formula…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael said: To update the teams' table with the points earned from the matches, I need use a script that loops through all the matches, evaluates the result,…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Retrieve a field from one table in another
Is there a link to contracts in the processing table? Can you list the direction N:1 or 1:N between the tables in events and in processing? When you edit the reference field it shows you the…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael You may want to think about renaming <_Partidos1 & 2. Maybe <_PartidosL and <_PartidosV. If you do that then you can change the code to: sum(<_PartidosL.'Ptos L') + sum(<_PartidosV.'Ptos V')
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael said: sum((select Partidos).'Ptos L') + sum((select Partidos).'Ptos V') but this plase the same result in all game, in the Equipos need the points for each teams.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett said: The question is really how to set the MC field as part of the code in an add new record trigger. It doesn't seem to work. If you are initiating from table2 then it is doing…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett The debugValueInfo is not supposed to be in your button code. See my post about how to use it. See the post to how to update the button. When you say "app" are you talking about MacOS,…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael please post your new code.
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael So use that relationship to do your sum().
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
@Chris Mullett said: I think, by clicking a bin icon, but there doesn't seem to be a way of doing this now It has been awhile since I tried to delete choices.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Formula for table ' Choice Dynamic'
what platform are you using? I can't duplicate it when I'm in the Cloud.
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Some help here
@Rafael said: This Formula SUM the same for all Teams need, need for each team. You are correct. Why don't you use the relationship link to Partidos? That way you only get related records?…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: multiple choice: delete option and set option on create new record
I'm sure that until recently it was possible to delete a row from the options of a multiple choice field. Now I can only edit the text and re-order the options.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Selecting Product Items based on Product
@Vermaji said: I have been advised by the veterans in Ninox and Ninox technical support that it is not a good idea to filter records using reference in a DCF element as it creates a chaos during data…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@Michael Cornelissen I've modified the DB to: 1) added a Yes/No field in Articles called Sub that allows you to specify if it is a subassembly. 2) I stuck with the material table as I just has…
Attachment
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
Here is something I made awhile back that show what could be done for your work orders as product/supply mgmt. It is made for 1 level between supplies and product.…
Attachment
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Populate text field based on selected option from a DCF
I suspect you are seeing a blank alert() is because when you do a select Ninox with no fieldname, Ninox always returns what appears to be blank but isn't. Ninox just doesn't know what to show you.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: If I upgrade to the new version 3.13 what would happen to my current database on the previous version?
Hopefully not much. If you are a cloud user then you are using the latest version weather you like it or not. The apps have not been updated yet, so if you use the cloud and the app then nothing…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@Michael Cornelissen Seems like Work Orders doesn't need to be a child of Invoice. Invoice is what the goes out to the client, and work orders are internal.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Table or Sub-Table?
@John Halls Was not implying you made any of DB mistakes that I made. I agree that you should try to use as few tables as possible. Some go the other way and create new tables when all they needed…
- Fred
- 5 mths ago
- 1
- Get help
- Reported - view
Re: Table or Sub-Table?
Don't worry about too many tables. The important thing is if the data is different enough to need a new table. Most people don't make enough tables. If you find yourself making field names with a…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Button for writing to another table
@iliper LTD said: What is interesting is that the record is displayed in the "advance" table itself, but it is not in the sub-table that is in the employee account.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji said: Please advise me if I am wrong about using SELECT statements. I am not knowledgeable at all of how Ninox's backend works, so I can't say if using select statments will make any…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Data in the OrderItems table changes on its own
@Vermaji said: I don't want to leave Ninox. I don't understand what should I do at this stage !! One option is to create another tables that stores the selection made in the dynamic choice.…
- Fred
- 5 mths ago
- Get help
- Reported - view
Re: Button for writing to another table
@iliper LTD 1) the variable i is the new record in the ADVANCE table so that is where it is looking and it looks like there is no field called EMPLOYEES.…
- Fred
- 5 mths ago
- Get help
- Reported - view

1 14 15 16 17 18 136

Welcome to the Ninox community

Fred

My Posts

Re: Retrieve a field from one table in another

Re: Some help here

Re: Retrieve a field from one table in another

Re: Some help here

Re: Some help here

Re: multiple choice: delete option and set option on create new record

Re: multiple choice: delete option and set option on create new record

Re: Some help here

Re: Some help here

Re: multiple choice: delete option and set option on create new record

Re: Formula for table ' Choice Dynamic'

Re: Some help here

Re: multiple choice: delete option and set option on create new record

Re: Selecting Product Items based on Product

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Populate text field based on selected option from a DCF

Re: If I upgrade to the new version 3.13 what would happen to my current database on the previous version?

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Table or Sub-Table?

Re: Button for writing to another table

Re: Data in the OrderItems table changes on its own

Re: Data in the OrderItems table changes on its own

Re: Button for writing to another table

Overview