Fred

San Francisco, USA

3381
533
4

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

My Posts

Latest Posts

Re: Registar
Hi there - Ninox, like many relational databases, can do a lot of things. If you have the MacOS app or a cloud account you can look at the Contacts template or the Events template to get an idea of…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Bulk edit yes/no
@Lisa Hinkel You can set Yes/No to null programmatically, but I do see your point. Yes/No start off as null then once you select a choice then it is either/or.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@Rafael You should always plan for a provider disappearing. I’m not saying Ninox will but you never know. Always have a copy of your data under your control.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
@James I originally bought the app. I made the move to the cloud when the app started to take a long time to be upgraded and fall behind in features. While the cost is quite a bit more, vs free,…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Payment of several unpaid invoices
@Nick said: Also, Fred, I linked the receipt to the customer because at first I ignored the invoice and entered the receipt as a credit to the customer This got me thinking and came up with this…
Attachment
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Payment of several unpaid invoices
@Nick Just some notes: 1) think about doing this from your dashboard instead of in Receipts. 2) Receipts don't really need a reference field to Customers, just Invoices.…
Attachment
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Duplicate record has stopped working
@James In my post, I tested it an it only happens with DBs that are in local/iCloud storage. The public cloud version is NOT affected in browser or app.
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Sorting a Table View by Dynamic Choice
@activelifejss said: I'm currently working from the cloud version so I'm not sure if I can export a sample DB from here If you have the starter version then you are correct there is no way to…
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Duplicate record has stopped working
@neathcarpets The big problem is Ninox will never tell us what they fixed, so you will have to keep trying it in each version and pray and pray.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Payment of several unpaid invoices
@Nick said: The tables are: Customers, Invoices, Receipts with the corresponding relationships between them. Can you upload a test DB?
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Duplicate record has stopped working
is it like this post?
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Sorting a Table View by Dynamic Choice
I have so many questions that it might be easier to see what is going on if you posted a sample DB.
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
@Michael Blechinger You can try adding the array() command to combine the ExpenseTwoMonthsOne and ExpenseTwoMonthsTwo into 1 big array then you don't have to have two loops.…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
@Michael Blechinger I didnt know that I loop1 doesnt need to be defined before Yeah, that is where Ninox is different then regular programming languages.…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Need to link each expense from this week to a record and then link it to the main table
You need to reference your for loop variable in the loop. for fixeAusgabenTabelle in ExpenseThisWeek do let thisExpense := this.ExpenseThisWeek; let newRec :…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss Or you can start a new post. That way we can focus on your question specifically. If you don't feel like writing out the fields and links, you can add a sample DB.
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss This post is about dynamic fields. Are you asking how to sort a view element or a table form? Are you using a dynamic field to modify a view element?…
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Help with this problem Thank you
@Angel Del Pino VelezI don't do any api work, so I don't have anything to add. To get the most eyes on this issue, I would recommend you start a new post.
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Sort Choice (dynamic) entries
@activelifejss said: but what about sorting the actual data in the grid view? What "grid view" are you talking about?
- Fred
- 10 mths ago
- Get help
- Reported - view
Re: Thoroughly delete image elements with code
Take a look at this post.
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: How to enforce unique values in text field?
@erik You can look at my sample DB in this post. If you have users use a dashboard/Page then you can control how data gets entered.
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: Help with this problem Thank you
Hi Angel - Attached is a sample DB. If you open the Dashboard table and the first tab shows you an appointment field and a button. When you select an Appointment then click on the button it will…
Attachment
- Fred
- 10 mths ago
- Learn and share
- Reported - view
Re: Type in a date on 1 table and it populates also in another table
There are two ways to go about it. The first way is to use a Trigger after update on the Date field that copies the data to another date field in another record.…
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: How to enforce unique values in text field?
@erikTake a look at this post. You can also use Dashboards/Pages to control some parts of the UI.
- Fred
- 10 mths ago
- 1
- Get help
- Reported - view
Re: How to count number of lines and contents
@Peter Oram said: So, formulas 2 & 3 would now need to be how many cells are populated in a certain column. If you can assist with that, that would be great.…
- Fred
- 10 mths ago
- Get help
- Reported - view

1 33 34 35 36 37 136

Welcome to the Ninox community

Fred

My Posts

Re: Registar

Re: Bulk edit yes/no

Re: Duplicate record has stopped working

Re: Duplicate record has stopped working

Re: Payment of several unpaid invoices

Re: Payment of several unpaid invoices

Re: Duplicate record has stopped working

Re: Sorting a Table View by Dynamic Choice

Re: Duplicate record has stopped working

Re: Payment of several unpaid invoices

Re: Duplicate record has stopped working

Re: Sorting a Table View by Dynamic Choice

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Need to link each expense from this week to a record and then link it to the main table

Re: Sort Choice (dynamic) entries

Re: Sort Choice (dynamic) entries

Re: Help with this problem Thank you

Re: Sort Choice (dynamic) entries

Re: Thoroughly delete image elements with code

Re: How to enforce unique values in text field?

Re: Help with this problem Thank you

Re: Type in a date on 1 table and it populates also in another table

Re: How to enforce unique values in text field?

Re: How to count number of lines and contents

Overview