Fred

San Francisco, USA

3409
539
4

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

My Posts

Latest Posts

Re: Adapt fórmula to new Structure.
@Rafael said: One Question. Wouldn't it be easier to create separate tables for each of the Real 3, 4, and 5 ? separate tables? or separate records? generally when you find yourself creating multiple…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Your code doesn’t copy those fields over. You need to add them to the newRec part.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
You have to follow your links to get the correct data now that you have changed your loop2 starting point. if count(loop2.'1N_Control Issues'[Date_ref = fDate]) < 1 then let newRec :…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ", ["Yes", "No"]); if check = "Yes" then for loop2 in (select 'dates by Documents')['Document'] do you changed line 3 to 'dates by…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael Wow, I guess I was smarter back then.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
if count(loop2.'1N_Control Issues'[Date_ref = fDate]) < 1 then let newRec := (create 'Control Issues'); newRec.( Date_ref := fDate; 'wbs Documents' := loop2 ) end end end end Line 1:…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael wow, looking at it now it looks like it shouldn't work. :) can you send me that DB again?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
@Rafael is the forum broken? I don't see any line numbers in your or my posts.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Adapt fórmula to new Structure.
I don't know where this code is supposed to go in your DB. Looking over the code and your DB I have the following questions: let check := dialog(" Warning ", " ¿Confirm the Update Transmittal ? ",…
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 66 67 68 69 70 137

Welcome to the Ninox community

Fred

My Posts

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Adapt fórmula to new Structure.

Re: Split Records

Re: delete records in dmcf with a button

Re: Split Records

Re: delete records in dmcf with a button

Re: delete records in dmcf with a button

Re: delete records in dmcf with a button

Re: delete records in dmcf with a button

Re: Responsive app iPhone

Re: If then question

Re: Can you exit from script based on IF condition

Re: Sub-BOMs Cost Managment

Re: Can you exit from script based on IF condition

Re: I login but only see a blank white screen and none of the data??? Can't get support, anyone know how to help.

Re: Sub-BOMs Cost Managment

Re: Can you hide Members and New/Import/Manage tiles on Cloud Login page

Re: Load (Transfer) Data

Overview