Fred

San Francisco, USA

3406
539
4

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

My Posts

Latest Posts

Re: How to Get Triggers to Work when Importing Records?
@Dave Irving said: so no way to create a server side script to run triggers upon an import? I guess there isn't, or Ninox would allow triggers to run on import.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Interesting scripting problem?
Here is a mock up of the N:N table idea.
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Interesting scripting problem?
Here is a simple solution: let t := this; let x := (select Employee where contains(numbers(Tasks), number(t))); concat(x.Name) Since you use a dynamic multichoice (dMC) field you have to use a select…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: JSON: add a block based on a given condition
Have you seen this post?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to Get Triggers to Work when Importing Records?
You may want to consider putting your trigger codes wrapped in a for loop in a button. That way you only have to press a button.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Display fields from a linked record
You use the reference field name. By default Ninox uses the table name for the reference field, so if you have a Table1 and Table2 and create a reference field in Table2 to Table1 then in Table2 you…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Auto link to N:2 root table
Just my two cents, but it seems like there should be a direct link between Company and Contacts then a N:N link between the two called Function. This way you can track specific data for that person…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
@Javier Gómez Great to hear. Please remember to mark the post answered when you get a chance.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
Are you creating these dMC fields in a third table, most likely a dashboard? Is country in tHotels a dC field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using a Dynamic multiple choice field to filter a dynamic choice list
Yeah, when you tell Ninox to check a contains of an array in another array it will not iterate through the choice array. It will just look to see if all of the numbers in the array appear in the…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Rant: More Server Issues
Looks like things may have cleared up. Late last night (about 11pm PST), there were 8 processes still running. This morning there are none so I made a change and it was saved. Only lost the weekend.
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Rant: More Server Issues

Sadly, again I lost my ability to work on my DB last night. Again on a Friday. I can't save any work. The app says I have 6 background processes going and it has been that way for hours now.…
- Fred
- updated 1 yr ago
- 2replies
- 79
- Learn and share
Re: Comments???
Here is@Jacques TUR 's excellent background on the use of #{}# as a comment delimiter.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna I don't do any printing, so I can't help you out there. Printing, in my opinion, is still a weak point of Ninox.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna said: Is there a way to get the choices sort by 1.group and then by 2.abc? Ninox can not do a multilevel sort with code commands. You have to create another field that combines the two fields…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
@Roger you are correct. sorry, I thought you were to original poster.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna Are you talking about sorting the table view or sorting the choices in a dynamic choice field?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: creating linked records from table A to tables B and C question
@Roger If you are satisfied with the answer, please mark the post "answered" so others who are looking will know if they should look at the post.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Filtering the table view
can you provide a sample db as I can’t seem to reproduce it, even in the iOS app.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Copy "text" field contents into "Choice" field?
If you Choice field is a simple choice field. First you need to make sure there is a choice for all possible data in the Text field. They need to be exactly the same (casing especially).…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Dynamic combobox/dropdown list
@Kruna said: what would be the solution, if I use multiple dynamic choice field? Ask and you shall receive.
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Those pesky"" when you don't want them.
Also works with [ ] and ( ). It was a very nice addition to the editor when they made the upgrade.
- Fred
- 1 yr ago
- 1
- Learn and share
- Reported - view
Re: forbid multi line copy paste in views ?
@PIERRE M I understand how it the issue works. I guess I would humbly disagree with your comment on “to develop a workaround on that, Ninox would lose most of its simplicity.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Switch Case Statement: combine multiple cases with same code
KrunaIf you want to use Jacques' sample then it would look something like: let n := number(Source) switch true do case [1,4][=n]>0: if TaxReqd = false and ResvDept = true then '01Hdr1pymtDep' else ...…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: is there a way to count number of item within a selection field?
Interesting idea. If you are using a simple choice/multi choice field then I would say there is no easy way to count the number of choices. Ninox has no way of looking into the choice field without a…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view

1 61 62 63 64 65 137

Welcome to the Ninox community

Fred

My Posts

Re: How to Get Triggers to Work when Importing Records?

Re: Interesting scripting problem?

Re: Interesting scripting problem?

Re: JSON: add a block based on a given condition

Re: How to Get Triggers to Work when Importing Records?

Re: Display fields from a linked record

Re: Auto link to N:2 root table

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Using a Dynamic multiple choice field to filter a dynamic choice list

Re: Rant: More Server Issues

Re: Comments???

Re: Dynamic combobox/dropdown list

Re: Dynamic combobox/dropdown list

Re: creating linked records from table A to tables B and C question

Re: Dynamic combobox/dropdown list

Re: creating linked records from table A to tables B and C question

Re: Filtering the table view

Re: Copy "text" field contents into "Choice" field?

Re: Dynamic combobox/dropdown list

Re: Those pesky"" when you don't want them.

Re: forbid multi line copy paste in views ?

Re: Switch Case Statement: combine multiple cases with same code

Re: is there a way to count number of item within a selection field?

Overview