Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3525
550
4

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

My Posts

Latest Posts

Re: Split Records
You can put the code of the button in the Trigger after update in the ITEM field in JOB or in the Trigger on new record for the JOB table (if you move CONDO to Service).
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: delete records in dmcf with a button
Sorry there was a bug when multiple records were not Auswahl = 1. Here is the corrected code: let curDMC := numbers('Mehrfachauswahl (dynamisch)'); let removeDMC :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Records
try this in a button: let t := this; for loop1 in JOB do for loop2 in loop1.CONDO.OWNER do let newRec := (create SPLIT_JOB); newRec.( SERVICE := t; CONDO := loop1.CONDO; OWNER := loop2; ITEM := loop1.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: delete records in dmcf with a button
You can try the following in a new button to test it out: let curDMC := numbers('Mehrfachauswahl (dynamisch)'); let removeDMC := unique('ausgewählte Dekaden'[Auswahl != 1].…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: delete records in dmcf with a button
@Kruna said: Then I need a further script to de-select/remove the respective record 'Test2', so that I can see only 'Test1' and 'Test3'. That is more clear.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: delete records in dmcf with a button
@Kruna said: Well actually both I would like to delete all records which are Auswahl !=1 and at the same time de-select the respective choices. Lets say eg there are five record and record 1 and 3…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: delete records in dmcf with a button
Your delete code: delete 'ausgewählte Dekaden'[Auswahl = 2 or Auswahl=3] does not reference a dMC field. Auswahl is a simple choice field. The one dMC field I could find is Mehrfachauswahl…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Responsive app iPhone
One way would be to use the NinoxApp() function. You would create a tab that is laid out for the iPhone and have it only visible on an iPhone and have your other one not visible on an iPhone.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: If then question
Easiest solution would be to use "in". Since you use "mm" why not continue to use letters. If you must use the double quote then you can try: let dquote := urlDecode("%22");…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Can you exit from script based on IF condition
@Matthew said: I was hoping for something a bit more simple like "if bday_reminder = No then EXIT" (or GOTO END) Sadly Ninox does not, to the best of my limited knowledge, have anything like this.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sub-BOMs Cost Managment
@Didier Schoonjans I think that is a big limitation of your current setup with Articles being linked to other Articles. That is why my sample DB has a materials table and an Article table.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Can you exit from script based on IF condition
One way would be to not have an ‘else’ part. But I’m suspecting your question is a bit more complicated than that. Can you expand on your situation?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: I login but only see a blank white screen and none of the data??? Can't get support, anyone know how to help.
I'm guessing you are using the MacOS app. If so then you can try the following: Terminal command please try the following to fix the problem: open the Terminal app You can find it via Spotlight…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sub-BOMs Cost Managment
Looking around your DB, when you get to line 7, if you can get the correct grouping of articles, what quantities do you want to multiply to figure out Cout? (sorry for the lack of proper spelling).
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Can you hide Members and New/Import/Manage tiles on Cloud Login page
You can always hide any table you want. Only admins can see hidden tables. I'm not sure where members are displayed so I can't answer that part.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
@Rafael said: 2- Then with the other button Create All Transmital generate again the info on 'Control Issue' with the all Documents. 3- When the Control Issue Table is update,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
@Rafael said: In the end I solved it via Bulk Edit. I image that is no possible to sequence the Bulk Edit in a Script to ad on a button This solution is for after the records in Control Issues have…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
@Rafael said: I've given this so much thought that I don't see it. Open a record in 'Control Issues', you will see the filed 'Issues Week'. It is empty.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
@Rafael The DB you upload does not have all of the tables you reference in this Post Reply. Back to your original post you say there is a 1 (Issues Week) to N (Control Issues) link,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Bug in MacOS v3.8.7 and iOS v3.8.11 app

Hi there - I seem to be having an issue with some code that doesn't do what it is supposed to do when I add "do as server" to it. This happens on iOS v3.8.11 and Mac OS v3.8.7.…
- Fred
- updated 2 yrs ago
- 1reply
- 69
- Learn and share
Re: Subtotals
@spinner. 7580 said: If there is more than one person accessing the database via a browser is it necessary to change the Binding parameter from the default?…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Load (Transfer) Data
@Rafael said: Need to Load the info on 'Control Issues' Table on 'Issues Week' Table on Reference 1:N 'Control. Issues_ You should have a field in each of the Control Issues records called Issues…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Load (Transfer) Data
You can duplicate the table. You can create a link between the two tables and just reference the records you need. You can create a button that creates the new records and copies the data.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Update multiple records
I was expecting to see Update multiple records as well, but I guess it is now called Bulk Edit. I don't remember seeing the ability when right clicking on a row number.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Update multiple records
on the cloud version I can "Bulk Edit" (that is new to me) and it updated the three records in my DB. Is that what you mean by "update multiple records"?
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 71 72 73 74 75 141

Back to top

Overview

View all topics