Fred's Profile | Ninox Community

Badges

Latest Posts

Re: Appointment function
@Jan Inge Iversen said: But why is the time showing wrong data in the other formula? It is "not showing" the wrong data. Ninox is assuming the data in the time fields are GMT.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Organize the result count system
@ekalcasino777 said: it is possible to display all data from Alltables to tables1 depending on the date, not using "View"? It is possible. You just need to create a formula field that points to the…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Copy contents of reference link to another field.
@Bernd Krell said: Then I select something else and it appends it. Possible? Most things are possible. You can try this in your trigger: let t := this; if Description = null then Description :…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: coding for create record
@Marjolijn said: I dragged the Sessies table into the Coachees table ("Reference from Coachees to Sessies (1:N)"). So what is the field name of the field you describe? Another way is,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: coding for create record
@mpm said: it makes a new record in the Sessies table with the Coachees.ID in the Sessies.Nr field. So now you put the name of the reference field link in the Sessies table, probably called Coachees.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Array to records in a table
Is there anyway to remove the "\"? When I try copying the bit of data Ninox gets all confused with the "\". There is no way that I can see, but I'm not the smartest,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: coding for create record
@mpm said: I tried your suggestion earlier (and just now again) but it still gives the same error: "Field is no data field" on line 4. Just the := is underlined in red.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: coding for create record
Can you post the code?
- Fred
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view

1 105 106 107 108 109 154

Welcome to the Ninox community

Fred

Re: Appointment function

Re: Organize the result count system

Re: Copy contents of reference link to another field.

Re: coding for create record

Re: coding for create record

Re: Array to records in a table

Re: coding for create record

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

Overview