Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Running a script for each record in a subtable...
@jason We are happy to help with the for loop as well.
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Running a script for each record in a subtable...
if you are comfortable, please post the final code so others can learn from your success.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Normalising existing data
I know someone else wrote up a nice response for this question, but I can't find it. Here is one possible solution. The code is in a button in Table2: let startTable := (select Table2); let Array1 :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dynamic Choice "order by Id" gives incorrect order
You don't need to order by Id. Ninox does that by default.
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Normalising existing data
Let me see if I understand your post. 1) you have a table (table1) that has duplicate data in a field (field1) 2) now you want to take the data in the field,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Running a script for each record in a subtable...
can you post the code you are working with and the names of the fields that links the tables? or post a copy of your db.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Running a script for each record in a subtable...
If you want to change the data in a field in all records of a related table, you can do something as simple as: let a := "New Text" ReferenceFieldName.textfieldname :…
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Import Users into Microsoft Active Directory from Ninox
I don't think this is the correct forum for this question. Just my 2 cents, if AD can take an excel file or csv then that sounds like the only way to do it. Unless Azure AD has some API links.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
Well then how does Ninox know which records to show if you are only doing a count? var a := numbers('Select characteristics'); select Contact where (var b := numbers('list of characteristics');…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Week_Appoitment
On my MacOS version and iPad through iCloud the db loads fine.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: acces to array items like with Where fonction
still trying to wrap my head around how count(c) = count(a) returns a value for the where command to work. it works but my wee brain is just not getting why it does.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Problem in Calc_Dynamic
@Rafael Look at line 2, base is a variable.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem in Calc_Dynamic
About your first issue, dynamic choice fields returns records from a table. And since your select statement is to get the whole table then you will see all records.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem in Calc_Dynamic
I was wondering why you converted all the sums to text then back to a number at the end. I see that at the beginning you did: let vInfo := ""; Which, I'm guessing,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Problem in Calc_Dynamic
Hi Rafael - I've poked around and came up with a model that will work with weeks. You can see it in the uploaded version. Here are the changes to the Trigger on Update of the Choice field:…
Attachment
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: sibling tables
@UKenGB said: Trouble is that once in the 'view' you're just looking at c2. So you can access any of p's data, but no way that I've found to get anything from c1 as that 'link' has been lost.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: statistics
can you upload a test db so I can see your structure?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Sam said: Fred Will you have multiple records in Table1 linked to a single record inTable2? yes So you can try this: let t := this; let newData := 'DATA ITEMS'.Data + " " + t.Data1; 'DATA ITEMS'.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Sam said: Fred I think it may be linked through the dMC ‘Other Data’ The Dynamic value is: let xTemplate := number (‘Other Data’); (select Table2)[‘Other Data’ = xTemplate] dMCs do not create a…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
@Sam said: let j1 := (create Table1); j1.(Data := i.Data); j1.(Table3 := xCurrRec) Question: is there a reason why you don't create the link to table2 when you create the records in the dMC trigger?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
Since Table1 has the reference field to Table2 (called Data Items) that means there is a 1 to many relationship between the tables, 1 record in Table2 has many related records in Table1.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy text field to reference field
Most things are possible.🙂 @Sam said: The reference fields DATA ITEMS and the Dynamic multiple choice field are pointed to the same table. Table2. The Dynamic multiple choice field is located in…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Get time in minutes from the duration field type
The duration field (or Time Interval) is a tricky field. Here is Ninox's definition of the field type (scroll down to Time Interval): Time Interval A Time interval is the time between two points in…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Cannot save views
I'm still on MacOS11 and Ninox app v3.6.8. Now you have me worried about updating the app. 😥 Don't know if the issues are related but to make sure your new views are saved you need to turn on Admin…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Body of Email field
Looking back at my code Ninox changed it so you can try: {if 'Is PPC to be included in report' then ‘Google Data Studio Link' end}
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 112 113 114 115 116 153

Welcome to the Ninox community

Fred

Re: Running a script for each record in a subtable...

Re: Running a script for each record in a subtable...

Re: Normalising existing data

Re: Dynamic Choice "order by Id" gives incorrect order

Re: Normalising existing data

Re: Running a script for each record in a subtable...

Re: Running a script for each record in a subtable...

Re: Import Users into Microsoft Active Directory from Ninox

Re: acces to array items like with Where fonction

Re: Week_Appoitment

Re: acces to array items like with Where fonction

Re: Problem in Calc_Dynamic

Re: Problem in Calc_Dynamic

Re: Problem in Calc_Dynamic

Re: Problem in Calc_Dynamic

Re: sibling tables

Re: statistics

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Copy text field to reference field

Re: Get time in minutes from the duration field type

Re: Cannot save views

Re: Body of Email field

Overview