Fred

San Francisco, USA

3420
539
4

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

My Posts

Latest Posts

Re: Organize the result count system
I'm unsure of the work flow you are describing for employees. I have to remember that when you talk about creating tables you are talking about gaming tables not DB tables.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: coding for create record
Can you post the code?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Resolving a bill of materials
@Fabian Wieland Can you create a new post and upload a sample DB?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create records from dynamic multiple choice
@Rafael said: When select Engineering I saw all elements on Engineering, Procurement, & Construction. I don’t see any problems on my end. When I select Engineering I only see Engineering.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create records from dynamic multiple choice
@Rafael said: Hi Fred, I try to use the formula to others Subcategory like Subcategory_2, etc but the formula don't work. I send A sample DB as example. I don't see anything wrong.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create records from dynamic multiple choice
@Kruna said: What I would like to achieve is when chosing two or more categories in table dmcf_table, that all the items from subcategories show up, eg Cars and Bike --> BMW, Mercedes, Toyota, Honda,…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Next Item in Line Formula
Looks like Step Order is an array. If so then you can try: item('Step Order',Step) You can check out their docs for more info.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Using a button to export multiple records
From the looks of it there is no way to export through a button. Maybe through javascript or through a json you can "export". One possiblility is the use of createTempFile,…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: MacOs Ventura and date format issue
Following the directions on this page would look something like: format(datefield,"MM/DD/YYYY") You will need to click on the link at the bottom to see the date and time formats.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Multiply for formula fields
Is Formula 1 a number result? You can try: number('Formula 1') * 'Formula 2'
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Updating Multiple Records with use of a button
Like most things in Ninox there usually is a way. You can try this in a new button: let t := this; for i in select Bible['Lesson Date' >= t.'Lesson Date'] do ...…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
@Jacques TUR It works now.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)
I get the same error with NativeJS to Forum DB. I'm on MacOS app 3.7.7. I have this in a formula field in another DB and it loads fine: var configLoadModules := { completion: false, badges: true,…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Functions of Buttons
Your buttons say "Create Table" and "Delete Table" do you mean records? What fields are in Table1 and Table2? What fields are in GM Table? Can you post a sample db?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Functions of Buttons
Is there some other data that links them like a date field or something else?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Functions of Buttons
@ekalcasino777 said: need a formula for this button, for duplicating all the data of the main table. I'm not sure if c is the main table or is t the main table? If it is t then. Try: for i in t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Python support.
Here is the link to the latest documents on API from Ninox.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula for adding
You seem to be asking two questions: Question 1: @ekalcasino777 said: I wanted to decide this way, create one more field, Numbers, and what we write there should be the default value for the main…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Accumulated by Staff Problem
You need to figure out why it is not adding the overtime hours. let vDate := Date; let vStaff := Staff; let vBefore := sum((select Carga_Horas)[Date <= vDate and Staff = vStaff].…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula for adding
Are you asking to compare the first digit in a number field to the sum of 5+5+6? The sum of 5+5+6 is 16 so how can one digit equal anything greater than 9?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Auto Number by ComboBox
@New Sun said: Suppose I cancel the second-row number. In your formula, the number of the second row is empty, Isn't that how you wanted it? @New Sun said: Suppose I cancel the second-row number.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Order by date from text field
I would agree that you need a new formula field that converts the data in the text field into a date format. I hope your data is in a consistent format in the text field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Auto Number by ComboBox
Since you already have an if statement I like to use a switch above it so it looks cleaner. I get lost when there are too many nested if statements. You said Ordered is a choice field.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Create a new record from a table directed to a specific TAB
There is a issue, at least on the MacOS version, with the openRecord where if the default view does not have the record in the found set then Ninox will not open the record.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
How to create a unique list of records

Let us say I have a table, Table1, with records that store years in a field called Number. Now I want to create a dynamic Choice field in Table2 that shows the unique years that are in Table1.…
- Fred
- 2 yrs ago
- 4replies
- 826
- 2
- Learn and share

1 89 90 91 92 93 137

Welcome to the Ninox community

Fred

My Posts

Re: Organize the result count system

Re: coding for create record

Re: Resolving a bill of materials

Re: Create records from dynamic multiple choice

Re: Create records from dynamic multiple choice

Re: Create records from dynamic multiple choice

Re: Next Item in Line Formula

Re: Using a button to export multiple records

Re: MacOs Ventura and date format issue

Re: Multiply for formula fields

Re: Updating Multiple Records with use of a button

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Ninext : Fields inspector (evaluate the impact of changing/deleting a field before to do)

Re: Functions of Buttons

Re: Functions of Buttons

Re: Functions of Buttons

Re: Python support.

Re: Formula for adding

Re: Accumulated by Staff Problem

Re: Formula for adding

Re: Auto Number by ComboBox

Re: Order by date from text field

Re: Auto Number by ComboBox

Re: Create a new record from a table directed to a specific TAB

Overview