Fred

San Francisco, USA

3617
572
5

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

My Posts

Latest Posts

Re: Copy Yes/No function value
I don't know where you want to copy but you just add your field names: let c := (create 'TABLE'); let t := this; c.(DATE := t.DATE + 1; yes/nofield := t.yes/nofield ); for i in t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Change "+ Create record"
@Kent Signorini said: Fred No, not right for that example. Well this is what I get: I don't know what you are after then.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Change "+ Create record"
@Kent Signorini said: For the sake of example, what query (select) would I use to duplicate the Cast subtable using a View on the Movies form in the Collections sample database?…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Multiple forms for a table?
@Kent Signorini said: But for follow up, is there any reason to have more than one Form type tab? (I realize you can get away without any, but the UI lets me add more than one...…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Minimum value 'number'
I guess Ninox treats 0 as a not. So you have to change the code to: if 'Number 1 = null then 'Number 1' := 'Number 4' end Then you can enter in a 0 in 'Number 1' and Ninox won't change it.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Multiple forms for a table?
@Kent Signorini Don't know what to say. I can't create forms that are blank. They always show all fields.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Multiple forms for a table?
Do you have a record in the Contacts table? The only way I could get a blank form is when there is no record in the DB. In addition, Columns have no affect on Forms.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Minimum value 'number'
Where is this code run from? Button? Trigger? Field 'Number 1' is what kind of field?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Check if 7 fields have been filled
@RoSoft_Steven Since you are more of an answer-er, you've never had to mark a post answered.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How do I set a link after update?
@Kent Signorini said: In the Quote's Branch field's "Trigger after update" I put this in: Branch.Company := Company What is not intuitive is what you wrote tells Ninox to make the Branch.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Change "+ Create record"
Unless @Jacques TUR has figured out a way to hack the UI of the reference table, there is no way to modify the UI like that. What you can do is use a View element.…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: For loop for accessing different fields
Maybe @Jacques TUR has a trick up his sleeve that can find the Ninox 'real name' for each field name.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Check if 7 fields have been filled
@webmaster.antonioferriero if it worked for you. please remember to mark the post answered so future searchers can be better informed. :)
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: In Out Button
@ekalcasino777 said: the first button gives the digit a prefix "+" and the second one should give the prefix "-", once you add a prefix then the numbers become text.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to merge columns together while merging unique cells & offsetting same cells
Finding duplicate records is pretty easy. If you create a new formula field you can put this in the formula section: let t := this; let x := select tableName[fieldName = t.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: copy and paste table between databases
@Richard v. Lothringen at the home screen of Ninox, click on the down arrow in the upper right corner of your DB icon. select duplicate database, uncheck boxes for data and images and attachments.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: In Out Button
When you say "a minus sign" do you actually want to put "-" in a field? What is the field name you need to change and what kind of field is it?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
@Jacques TUR said: Also, if you replace [^0-9]+ by ^[1-9]+, it's replace my (0*) and it stay only 3 groups (not 6) : I'm not sure why you started with 1 instead of 0.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Check if 7 fields have been filled
Oops forgot: just extend the variables at top to include the remaining fields and extended the trackingarray to include the new variables.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Line feed/Carriage return in an Alert
It is weirdly simple in Ninox. You would write your code like: alert("The quick brown fox jumped over the lazy dogs.") Here is a sample of some code that uses a variable that has text with carriage…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Help with Structure
If Projects are related to Bookings and Factory Orders through Quotes then you can create view elements and put this in the formula section: Quotes.Bookings or Quotes.'Factory Order'
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Extract certain variable numbers from attached file title
I stayed away with hard coding the "-" and the "x" as I wanted to make something that was more flexible. I guess dropping the leading 0's are ok. I went the with what was in front of me.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Check if 7 fields have been filled
You can try something like: #{ These sets of variables are used to test if fields are emtpy then creates an array of the fieldname(s) that are empty. }#; let x1 := if Name = null then "Name" end;…
- Fred
- 2 yrs ago
- 2
- Get help
- Reported - view
Re: Share information between two tables
@ekalcasino777 said: I have the "Date" field in both places, but the formula doesn't work. I checked both formulas. First one no mistake but not work I would check that there are records that meet…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Share information between two tables
If the date field is in AllTables: first((select AllTables)[dateField = t.dateField and 'Table Name' = t.'Table Name'].'Number23') If the date field is in 'Table Name':…
- Fred
- 2 yrs ago
- Get help
- Reported - view

1 95 96 97 98 99 145

Welcome to the Ninox community

Fred

My Posts

Re: Copy Yes/No function value

Re: Change "+ Create record"

Re: Change "+ Create record"

Re: Multiple forms for a table?

Re: Minimum value 'number'

Re: Multiple forms for a table?

Re: Multiple forms for a table?

Re: Minimum value 'number'

Re: Check if 7 fields have been filled

Re: How do I set a link after update?

Re: Change "+ Create record"

Re: For loop for accessing different fields

Re: Check if 7 fields have been filled

Re: In Out Button

Re: How to merge columns together while merging unique cells & offsetting same cells

Re: copy and paste table between databases

Re: In Out Button

Re: Extract certain variable numbers from attached file title

Re: Check if 7 fields have been filled

Re: Line feed/Carriage return in an Alert

Re: Help with Structure

Re: Extract certain variable numbers from attached file title

Re: Check if 7 fields have been filled

Re: Share information between two tables

Re: Share information between two tables

Overview