Fred

San Francisco, USA

3608
568
5

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

My Posts

Latest Posts

Re: Help with code to create non-repeating set of 10 numbers
@Alain Fontaine Awesome! That works great. Would've never thought to use the slice() command. It still reads to me that there should be a leading zero since you are asking for the first item and zero…
- Fred
- 1 yr ago
- Get help
- Reported - view
Help with code to create non-repeating set of 10 numbers

So I'm working on trying to create a non-repeating set to 10 randomly selected numbers between 0 and 9. I have this in a formula field: let x := [number(void)]; while length(x) < 10 do let newItem :…
- Fred
- updated 1 yr ago
- 12replies
- 80
- Get help
- Answered
- Answered
Re: Populate a field with values from a list
This was an interesting ask. Here is my 2 cents on the matter. Put the following in a button and have a text field called Text on the same form. let letterArray := ["A", "B", "C", "D", "E", "F", "G",…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Date field does not remain empty
Wow, I thought this would have been fixed by now. Here is a post from a year ago with the same issue. I tried it out in 3.12.2 and was only able to reproduce it only on local stored DB.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Populate a field with values from a list
Do you want a true random selection of values? Where you can get the same random number? Or do you want to exclude previous selections?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
This happens in both the public cloud and local DB with app v3.12.2.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
Well that is weird, I tried out your code@我是我的我 and Ninox only shows an alert for the last record that doesn't match the criteria. I would have thought an alert would've popped up for each instance…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
@我是我的我 That means multiple alert windows will pop up. Are you using@John Halls new code? Where do you think the the if statement should go? Give it a try. Post where you think it might go.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Trigger after hide bug
I haven't seen this before. Good job in finding it. Maybe move the Trigger after hide to Trigger after update of a particular field or the table?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of modifying a sub-table of a sub-table.
@我是我的我 Can you go over the conditions again? If nb >= 3 then.... if NOT then....
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Issue with a script that does not display the expected value when two fields are equal
Is this the same code as below? let Pgr := (create 'Progress-Disciplines'); Pgr.(Discipline := xFld0); Pgr.('Date CutOff' := xFld1); Pgr.('Week CutOff' := xFld2); Pgr.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Selecting Location for Local DB on Mac
@eric said: I just want to share the database between two computers Also you should be aware that if you do use two computers you won’t be able to modify the DB on both computers.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Selecting Location for Local DB on Mac
May I ask why a shared folder but not iCloud? Did you want to share the DB with another user on another computer on a local network? Ninox currently doesn't offer the ability to store the DB beside…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to use code to remove extra information?
You can try: let xBreak := urlDecode("%0A"); "// Split the text into lines"; let lines := splitx('Text 2', "\n"); "// Filter out empty lines"; let nonEmptyLines := lines[!= ""];…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Previous record
@Sotirios Zormpas I like the use of the record() command. I probably would've started with a select(), but this is much faster. May I recommend that with any new code,…
- Fred
- 1 yr ago
- 2
- Get help
- Reported - view
Re: Some idea ?
@Rafael Sorry for not being more clear. Look at the two lines. There is a word missing and a semicolon that is not needed.
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Some idea ?
@Rafael I made a mistake on line 6, what is the difference between the two loops statements?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Some idea ?
You can try this: let vDd := 'Add Data|Date'; let check := dialog(" Warning ", " ¿Confirm the Progress Update by Disciplines ? ", ["Yes", "No"]); if check = "Yes" then for loop1 in select 'CutOff…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Choice (dynamic) Combobox Behavior
@Mike Nichols said: Currently it ain't pretty but it works except that when an option is selected from the dropdown, the position integer is written to the textbox instead of the selected text.…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Previous record
Will you ever enter two records with the same date? Might you ever enter in a record that is not sequential? You forgot a day and now want to go back and add it after you have added subsequent days?…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Some idea ?
Just to verify that you want to add a second loop inside the first loop? So instead of let xPry there would be another loop?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: NINOX upgrade question - is it worth it?
@Louis Cornacchia I didn't experience any need for coding changes. I don't think they depreciated anything. Well at least I can't remember. I use the public cloud so I no choice but to keep up.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: NINOX upgrade question - is it worth it?
I would think this new function would be a game changer. do as database Also, is autofill of commands after 3.8? createXLSX? Here is the complete list.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Choice (dynamic) Combobox Behavior
Sadly there is not anything built into Ninox that allows updating of the dynamic field reference table through the dynamic field. It is a one way street where it only gets data from the table.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Regarding the issue of the record limit in the database.
@我是我的我It is not cheap. You will have to contact them. I think there is a minimum number of license, I think 5. Nioxus offers the ability to only purchase a single private cloud license.
- Fred
- 1 yr ago
- Get help
- Reported - view

1 32 33 34 35 36 145

Welcome to the Ninox community

Fred

My Posts

Re: Help with code to create non-repeating set of 10 numbers

Help with code to create non-repeating set of 10 numbers

Re: Populate a field with values from a list

Re: Date field does not remain empty

Re: Populate a field with values from a list

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Trigger after hide bug

Re: Regarding the issue of modifying a sub-table of a sub-table.

Re: Issue with a script that does not display the expected value when two fields are equal

Re: Selecting Location for Local DB on Mac

Re: Selecting Location for Local DB on Mac

Re: How to use code to remove extra information?

Re: Previous record

Re: Some idea ?

Re: Some idea ?

Re: Some idea ?

Re: Choice (dynamic) Combobox Behavior

Re: Previous record

Re: Some idea ?

Re: NINOX upgrade question - is it worth it?

Re: NINOX upgrade question - is it worth it?

Re: Choice (dynamic) Combobox Behavior

Re: Regarding the issue of the record limit in the database.

Overview