Fred's Profile | Ninox Community

Badges

Latest Posts

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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 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
- 3 yrs ago
- Get help
- Reported - view
Re: v3.7.8 MacOS carries a defect over from iOS
Heard back from Ninox and that is a feature now. :) You have to right click on link table columns to now bring up the contextual menu. Which actually makes more sense,…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Choose multiple linked records?
@Kent Signorini said: So I also just found videos on using Dynamic Multiple Choice fields to build a many-to-many relationship that way. Is there any reason why I couldn't do that here and still…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Extract certain variable numbers from attached file title
So now i'm on a regex kick. You can modify the regex part of the formula below to say: extractx("NAME-Nr001-200x400cm-Backlight-2021", "(\d+)[^0-9]+(\d+)[^0-9]+(\d+)", "",…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Choose multiple linked records?
@Kent Signorini said: Appointment and Services should actually be a many-to-many relationship: Then you need a third table that has reference fields to Appointments and Services.…
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: Extract certain variable numbers from attached file title
I guess I'm going to learn a bit of regex. :) Try this in a formula field: extractx("NAME-Nr001-200x400cm-Backlight-2021", "(\d+).(\d+).(\d+)", "", "$2") You can replace the first text in quotes with…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Extract certain variable numbers from attached file title
Seems like you are comfortable with extractx so you would use that to find the correct sequence of numbers. I could never get the hang of regEx so I can’t post the code here. Good luck
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Timer for delete record
There isn’t a “timer” in Ninox. You can: Create a formula then have it run when you open the DB, or table, or tab Put the formula in a button, that you have to click every day
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: Copying a record using button or Ninox icon
imageFieldname := null clears out an image field for me.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Keep documents in field on every new record
Let us know if you need help with the formula.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Keep documents in field on every new record
My first question, why a PDF (or attachment) needs to be duplicated it in every record? In a DB you try to not duplicate data across tables unless you need to be able to change it on a per record…
- Fred
- 3 yrs ago
- Get help
- Reported - view
v3.7.8 MacOS carries a defect over from iOS

If you haven't updated to v3.7.8 on MacOS, DON'T! Lucky you. There was a bug in iOS that didn't allow you to filter reference field tables. It wasn't in MacOS in v3.7.6 (the last version I was at).…
- Fred
- 3 yrs ago
- 1reply
- 63
- 1
- Learn and share

1 104 105 106 107 108 154

Welcome to the Ninox community

Fred

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

Re: v3.7.8 MacOS carries a defect over from iOS

Re: Choose multiple linked records?

Re: Extract certain variable numbers from attached file title

Re: Choose multiple linked records?

Re: Extract certain variable numbers from attached file title

Re: Extract certain variable numbers from attached file title

Re: Timer for delete record

Re: Copying a record using button or Ninox icon

Re: Keep documents in field on every new record

Re: Keep documents in field on every new record

Overview