Fred

San Francisco, USA

3373
533
4

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

My Posts

Latest Posts

Re: Select top 10 records from view
That is a very good question. The only other way would be if you can get the records you need in Website Support through a reference field. Can you post a picture of your data model?…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: hide add record
Do you want a table like view of some specific data to present? Do you want people to be able to make a choice? What do you exactly want this new feature to do?
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Address split into separate fields
So I tried using U Man Genius' Ninox ChatGPT for this and this is what it recommended: function getCity(address : text) do "Extracting the city name"; var parts := split(address, ", "); var location :…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Verknüpfte Tabelle: Kachel Ansicht
I would think you could use html tables, urlof(), and an image file to be a button. Take a look at@Sotirios Zormpas great post.
- Fred
- 2 mths ago
- Learn and Share
- Reported - view
Re: Relations between records in the same table
Since all of the data is the same it would make sense to have one table. I have made a test DB to show how it could look. Open the OneTable table to see how it works.…
Attachment
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Address split into separate fields
You might have to make the following change to the Address field: let regexCode := "(.*?)" + City + ","; extractx(firstStep, regexCode, "i", "$1") I found this address:…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Address split into separate fields
If this is for a business then there are companies that can provide you with a csv that you can import. Or even better maybe through API you can get the data.…
Attachment
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Table specific calendar view?
Check out@Sotirios Zormpas great HTML tools, one being a calendar.
- Fred
- 2 mths ago
- 1
- Learn and Share
- Reported - view
Re: Pricing and features
2. yeah, there is no "free" access to ninox. One option if you want a cheaper option for customers is to use a middlewear like Zapier or Make to link a webpage or a Google Form to your DB.
- Fred
- 2 mths ago
- 1
- Learn and Share
- Reported - view
Re: Display of columns in table 1:N
@iliper LTD That looks like the actual table view. What are the columns in the reference view element? The table that is just above the Add existing record button.
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Display of columns in table 1:N
The add existing record button shows the exact same columns that are in the reference view table. So change the columns in the view and it will change in the add existing.
- Fred
- 2 mths ago
- Get help
- Reported - view
How to download a copy of your DB.

I'm posting this so others can reference it if users are unsure how to download a copy of their DB to post in the forum. In the MacOS app: open the DB click on Table menu and select Export data click…
- Fred
- 2 mths ago
- 1reply
- 73
- 2
- Learn and Share
Re: Address split into separate fields
Without a separator between address and city I think you would have a very difficult time figuring out programmatically when an address ends or a city begins.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Create an Array from a dynamic Choice field
You are very close. Since you have var a, you don't need var aa. You need to reference your loop variable that references the ISTRUTTORE record that you selected in ISTRUTTORI.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@RoSoft_Steven I thought I've tried that and was unsuccessful, but if you vouch that it works then I agree that this the way to go.
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: if statement in choice field for dynamic printing
Cause I haven't done this before, I thought I would figure it out in Carbone. It could look something like: {d.rights:ifEQ(Yes):show('Yes Text'):or(.rights):ifEQ(No):show('No Text'):…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie JSON is just a way of organizing data, kind of like creating a table on the fly. You have a key or field names (the name to the left of the colon) and the value or data…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: if statement in choice field for dynamic printing
The easy way is to just add it to your JSON. usageRights: switch text(Rights) do case "Yes": "This my my Yes text." case "No": "This my my No text." case "Limited": "This my my Limited text." end
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie Produkt is a reference field, so you can pull any fields from it. Try adding the field name you need.
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: Dynamic invoices (.docx) with subtable - problem
@Johanna Schmidt Fotografie here is what it should look like. You just use the new names exactly as you typed it.
Attachment
- Fred
- 2 mths ago
- 1
- Get help
- Reported - view
Re: BugReport: Cannot access ChildObject if it has same name as parent
email Ninox directly or post on the German version
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
@George Tanev take a look at the styled() docs.
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Change the color of Number text(field) depending from the value
If you are in form view then there is no way to change the text color, even manually, in a number field. If you are in table view then you can add a conditional format rule to the column for Number 1.…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: How can I calculate which week of the month a specific day falls into in Ninox?
@Alain Fontaine Just letting people know that is what happens. So they shouldn't be surprised when they see a 6th week.
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Copying files
are the files in an image field or in the attachment section of the record? Also take a look at Jacques' post about copying files.
- Fred
- 2 mths ago
- Get help
- Reported - view

1 3 4 5 6 7 135

Welcome to the Ninox community

Fred

My Posts

Re: Select top 10 records from view

Re: hide add record

Re: Address split into separate fields

Re: Verknüpfte Tabelle: Kachel Ansicht

Re: Relations between records in the same table

Re: Address split into separate fields

Re: Address split into separate fields

Re: Table specific calendar view?

Re: Pricing and features

Re: Display of columns in table 1:N

Re: Display of columns in table 1:N

Re: Address split into separate fields

Re: Create an Array from a dynamic Choice field

Re: Dynamic invoices (.docx) with subtable - problem

Re: if statement in choice field for dynamic printing

Re: Dynamic invoices (.docx) with subtable - problem

Re: if statement in choice field for dynamic printing

Re: Dynamic invoices (.docx) with subtable - problem

Re: Dynamic invoices (.docx) with subtable - problem

Re: BugReport: Cannot access ChildObject if it has same name as parent

Re: Change the color of Number text(field) depending from the value

Re: Change the color of Number text(field) depending from the value

Re: How can I calculate which week of the month a specific day falls into in Ninox?

Re: Copying files

Overview