Fred

San Francisco, USA

3420
539
4

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

My Posts

Latest Posts

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
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- 1reply
- 63
- 1
- Learn and share
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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 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
- 2 yrs ago
- Get help
- Reported - view

1 88 89 90 91 92 137

Welcome to the Ninox community

Fred

My Posts

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

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

Overview