Fred

San Francisco, USA

3699
591
5

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

My Posts

Latest Posts

Re: Organize the result count system
@ekalcasino777 said: We have one problem, if the next day we change the data of the Alltables in "GM TABLE", then they remain the same in the table. Therefore,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: coding for create record
What kind of field is 'S-nr'? Can you try this simplified code? let a := this; let i := (create Sessies); i.( Nr := a ); openRecord(i)
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: coding for create record
@mpm said: I need to create a new record in Sessions (with client-ID, client-Name automatically filled from the client record and a link to the main client-table) with a button in the client-table.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: coding for create record
It is a bit of a slog through the forums to find what you need. Question: are there fields with the names of 'k' or 'vn' in the table Sessies? If these are references to the variables created above…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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

1 100 101 102 103 104 148

Welcome to the Ninox community

Fred

My Posts

Re: Organize the result count system

Re: coding for create record

Re: coding for create record

Re: coding for create record

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

Overview