Separating List into Objects

Hello, I have a list of items that are separated by commas: Objects = "Red, Blue, Green" I would like to convert them to objects, and loop through each object to see if a condition matches. Ex.…

Loop through Records

I am creating a user access module. System User User Group User Permissions None of these records are related. My goal is to use Dynamic Choice fields. So a user can be a part of multiple User Groups,…

Return JSON

Hello, I have this JSON data that is returned from a SQL select statement: {"result":{"recordsets":[[{"status":"Enabled"}]],"recordset":[{"status":"Enabled"}],"output":{},"rowsAffected":…

Replace array of items

Is it possible to utilize the replace() function with an array of options to check? Something like: replace('My Text', [ "Hello", "Goodbye", "Welcome" ], "Custom Message")

Loop Syntax Correction

Hello. I am having a bit of trouble with this for-loop, a syntax error and would love an extra pair of eyes on this, I basically have a 'Hire Date' field,…

• Answered

Bug in Ninox workdays() formula

As a member of the Ninox beta team, I am no longer sure where to report bugs. However, I did find a bug with the workdays() formula. According to https://docs.ninox.…

Multi-Choice (Dynamic) Field

Ahhh, Multi-Choice (Dynamic).... Truly a wild animal. I have a dynamic multi choice field to select multiple records in a table, staff. How do I get the Staff.…

• Answered

Code Simplification - Loop ?

Hello, I am trying to simplify this code let num := number(Deduction); let rec := record('Taxes/Deductions',num); let ths := this; if rec.Calculation then ths.(Calculation := rec.…

• Answered

Dynamic Choice Field Assistance

I am having some trouble with a dynamic field: let ths := this; let thisUserDepartment := ths.Department.Id; let thisUserTitle := ths.'Job Title'.Id; (select 'WFM Permissions' where numbers('Eligible…

• Answered

Next Item in Line Formula

I am creating an approval flow in Ninox. I have a field named 'Current Step' and a list of that displays the order of the steps. Named 'Step Order' and the value is '1,2,…

• Answered

Import Users into Microsoft Active Directory from Ninox

Hello, I have a table in Ninox used to manager users. What is the best way to automatically import (create, modify) users in AD based on the changes in Ninox?…

Auto Import into Table

Is there a way in Ninox to auto import a CSV or plain text document into a specific Ninox table? Perhaps a PowerShell script of some sort.