Fred

San Francisco, USA

3747
594
5

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

My Posts

Latest Posts

Re: How to auto create new record every day?
@Nguyen Nhat Dong what is the name of the table and the name of the fields that you want set when a new record is created?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
that would be great.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto create new record every day?
There isn't a way to run a script based on time. You can do the create() command when you open the DB, Trigger on open. You can add code that will check if a record for the day already exist and only…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using a table selection in script
@Chris Mullett said: Basically I'm trying to bulk update records which I manually select and which are not necessarily selectable by query. May I recommend that you look into using a dynamic multiple…
Attachment
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Using a table selection in script
Hi Chris - Most things are possible in Ninox. @Chris Mullett said: I'd like to be able to scroll through a set of records in a table and update values on each record.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Mac app upgrade to 3.11.8 failure !!
Looks like an email to support is necessary.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
@Mr. K. I was guessing Lettering was the multichoice field. Is it?
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
Interestingly this doesn't work on dynamic multi choice fields through the Bulk Edit. Looks like dynamic multi choice fields need to be updated by a button.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Update Multiple Records... of a Multiple Choice Field
I didn't know you wanted a Bulk Edit code. It would look very similar to the button code I posted. You can choose Assign calculated value and put this for the code: let selectedArray :…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to select different options in bulk?
If you only need to do this once then you can use the Bulk Edit and put this code in the Assigned calculated value part next to Star. if 'old code' < 100 then 1 else 2 end If you need it in a button…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Infinite loop
@SimonS I'm sure Support will know of a way to deal with this issue.
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Infinite loop
I have the file location for the preference file on MacOS. You can email Ninox support and ask about how to delete the preference file on iOS. Maybe it is just deleting the app and reinstalling,…
- Fred
- 1 yr ago
- 1
- Get help
- Reported - view
Re: Charging for use of application.
What are the options? An annual/monthly site wide license? An annual/monthly per user license? What are you going to do with the data at the end of the project? You have to pay for:…
- Fred
- 1 yr ago
- Learn and share
- Reported - view
Re: Minimum cost (coding help)
@James said: Can triggers change a field which already has a formula at work? @James said: Is it possible to incorporate a trigger when a product is selected to put a minimum value of 60 into…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Minimum cost (coding help)
Just to verify, are you saying if Product.Type = 1 then the else of: 'Sq.m' * 'Fitting Rate' * 1.2 doesn't run? or if Product.Type = 6 and Room = 1 then: ceil((('Sq.m' * 'Fitting Rate' + 40) * 1.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Bulk edit yes/no
@Rafael are you asking a question?
- Fred
- 1 yr ago
- Get help
- Reported - view
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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr 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
- 1 yr ago
- Get help
- Reported - view

1 47 48 49 50 51 150

Welcome to the Ninox community

Fred

My Posts

Re: How to auto create new record every day?

Re: Mac app upgrade to 3.11.8 failure !!

Re: How to auto create new record every day?

Re: Using a table selection in script

Re: Using a table selection in script

Re: Mac app upgrade to 3.11.8 failure !!

Re: Update Multiple Records... of a Multiple Choice Field

Re: Update Multiple Records... of a Multiple Choice Field

Re: Update Multiple Records... of a Multiple Choice Field

Re: How to select different options in bulk?

Re: Infinite loop

Re: Infinite loop

Re: Charging for use of application.

Re: Minimum cost (coding help)

Re: Minimum cost (coding help)

Re: Bulk edit yes/no

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

Overview