Fred's Profile | Ninox community

Badges

Latest Posts

Re: Normalising existing data
@Rafael Ok, so what are you trying to do in your DB?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Running total every 5 days
Just to be clear, sounds like you want all days of the week except Saturday. You can try either of the following formulas: 1) weekdayIndex(datefield) - will return a number with Monday = 0 - Sunday…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Normalising existing data
@Rafael Sadly, I don't. I reused the button for something else. Is there some question you have about the code I posted?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Running a script for each record in a subtable...
Or this could work as well, put it right below the openURL. let array2 := first((select 'Claim Infringement')[URL = loop1]); let newRec := (create ArchiveHistory); newRec.…
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Running a script for each record in a subtable...
@jason said: The code I used to create a new record for Devonthink doesn't work in this code for Wayback - presumably because I'm working on an array of a specific field rather than a table…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Dynamic Choice "order by Id" gives incorrect order
join the club. 😀
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Running a script for each record in a subtable...
Glad things are working. Their documentation is horrible. I’ve learned by watching the Nioxus videos and this forum.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Running a script for each record in a subtable...
for a in unique(this.'Claim Infringement'.'Infringing Page URL') do openURL(a.'Infringing Page URL'); end; In line 1, you use the this command. I don't think you need it as you are using links to get…
- Fred
- 3 yrs ago
- 1
- Learn and share
- Reported - view
Re: Running a script for each record in a subtable...
Is this code in a button? If so, when you click on the button do you want the DB to open each link?
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
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

1 116 117 118 119 120 157

Welcome to the Ninox community

Fred

Re: Normalising existing data

Re: Running total every 5 days

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: Dynamic Choice "order by Id" gives incorrect order

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

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

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

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

Overview