Skip to main content
Forum
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Solutions
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3617
572
5
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
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
Fred
2 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 reference.…
Fred
Fred
2 yrs ago
Learn and share
Reported - view
Re: Dynamic Choice "order by Id" gives incorrect order
join the club.
Fred
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 yrs ago
Learn and share
Reported - view
Re: Week_Appoitment
On my MacOS version and iPad through iCloud the db loads fine.
Fred
Fred
2 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
Fred
2 yrs ago
Learn and share
Reported - view
Re: Problem in Calc_Dynamic
@Rafael Look at line 2, base is a variable.
Fred
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 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
Fred
2 yrs ago
Get help
Reported - view
Re: statistics
can you upload a test db so I can see your structure?
Fred
Fred
2 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
Fred
2 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
Fred
2 yrs ago
Get help
Reported - view
1
104
105
106
107
108
145
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Solutions
Ninox E-Invoice
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Performance
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
