Fred

San Francisco, USA

3701
591
5

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

My Posts

Latest Posts

Re: How to auto-fill the relationship field choice?
@Nguyen Nhat Dong Remember, I do not know anything about your DB, so I'm just guessing. 1) what is the table name that the Reference filed 'NGAY THU/CHI' points to? Put that table name after select.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Duplicate several records with changing one of the fild values
You could try something like this in a button: let findRecs := select tablename where fieldname = something; for loop1 in findRecs do let newRec := duplicate(loop1); newRec.…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: Delete all attachment from a subset of record
Take a look at this post about the code to delete paperclip attachments. I don't know if you can change things around and use a subtable to store attachments as it would be much easier to delete…
- Fred
- 1 yr ago
- Get help
- Reported - view
Re: How to auto-fill the relationship field choice?
If the table NGAY THU/CHI has a date field called Date then you can test it out in a button with: let selectNGAY := first(select 'NGAY THU/CHI' where Date = today()) 'NGAY THU/CHI' :…
- Fred
- 1 yr ago
- Get help
- Reported - view
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

1 45 46 47 48 49 149

Welcome to the Ninox community

Fred

My Posts

Re: How to auto-fill the relationship field choice?

Re: Duplicate several records with changing one of the fild values

Re: Delete all attachment from a subset of record

Re: How to auto-fill the relationship field choice?

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

Overview