Fred

San Francisco, USA

3376
533
4

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

My Posts

Latest Posts

Re: How to import local database from external HDD?
You should email tech support at support@ninox.com
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
The picture from May 30 10:17pm doesn't change the formula field into a text field. What it is showing you is that the data in the field is text. The field is still a formula field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
It looks like the formula is working. The records you show do not show "x" in both Trés petite taille and Petite taille so then there is nothing in petits et trés petits.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Please tell us what do you want to happen? what tables are you using? What fields are you using? are you in a record or are you looking at a table view?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Maybe you can tell me exactly what you are trying to do. Your last formula doesn't need an end, if you are just doing a select.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
Don't you then do a select like: select Table1 where field1 = "x" and field2 = "x"
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two search in a base
When you say "cross" are you typing in the letter "x"? Or is this an icon? What kind of fields are they (text, number, etc)?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Impossible to put some pictures in Ninox !
If you can't drop it in, then Ninox probably does not support WEBP format.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: REST API filtering
Hi Aniko - The forums is not official tech support. If you want help from Ninox then you need to email them directly at support@ninox.com or attend one of their Tuesday help sessions.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I create a formula to sum amount within each month from a range of dates? I am trying to sum all commissions paid on invoices where payment is made by each sales person.
Maybe I can help. First a few questions: How were you planning on setting the range of dates you want summarized? Do you want to see a list of all commissions paid to each sales person in one view or…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
"Name" is the actual name of the field in the Provider table. I don't know what the text field name is for you, so you just need to replace it with your field name.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: how to play with internal references ?
Hi Laurent - try adding this to your code: let curRec := this; first(select 'table 2' where 'cell a' = curRec.'cell a') In Ninox "this" is a simple command to tell the software to gather data from…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: date format DD/MM/YYYY
Hi there - Here is how you can reformat data fields: https://ninox.com/en/manual/calculations/reference-of-functions-and-language Scroll down to Date Functions (a long way down).…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
Did you setup your DB like in the thread below?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
I'm guessing that Payments.Provider field is a NOT a dynamic choice field. It is a bit tricky using dynamic choice fields and then using that data to do searches.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
something like:
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
Can you do a screenshot of the following: 1) open CatSvc table, click on the gear icon and select Edit Fields 2) take a screenshot of the table name and all the field names
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: I think we have a new record for spam posts
I have decided to email support@ninox.com everytime I see spam. And each time I ask when will they solve this problem. Not saying we should all do this but...
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
So when you are in the Baker record of your payment table, when you click on Services nothing shows up? I only ask about a baker because it is the only record with a category selected.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
Yea, the pics worked! Now can I get some pics of the edit fields windows?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: How do I get dynamic Choice field towork?
We would need some screenshots of the CatSvc table fields and the table fields that curRec refers to.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: VLOOKUP formula between 2 tables
you can try changing the first line to: let Name := chosen(Employé); <--since it is a multiple choice field (or even a choice field) the chosen command returns the text of the field.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Change Rich text field to Multiline text field - so can export to excel with code
Hi Joanna - Let me see if I can help. To remove the HTML code from Rich Text fields you can do create a formula field an put this in the formula section:…
- Fred
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Get value present in a field before the trigger of the same field
Is this a regular multiple choice or a dynamic MC?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox
I'm confused. Back on May 16th you said things are working. Now it sounds like you are saying things are not working. Which is it? Please show what the edit fields window looks like for the Provider…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 125 126 127 128 129 136

Welcome to the Ninox community

Fred

My Posts

Re: How to import local database from external HDD?

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Two search in a base

Re: Impossible to put some pictures in Ninox !

Re: REST API filtering

Re: How do I create a formula to sum amount within each month from a range of dates? I am trying to sum all commissions paid on invoices where payment is made by each sales person.

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Re: how to play with internal references ?

Re: date format DD/MM/YYYY

Re: How do I get dynamic Choice field towork?

Re: How do I get dynamic Choice field towork?

Re: How do I get dynamic Choice field towork?

Re: How do I get dynamic Choice field towork?

Re: I think we have a new record for spam posts

Re: How do I get dynamic Choice field towork?

Re: How do I get dynamic Choice field towork?

Re: How do I get dynamic Choice field towork?

Re: VLOOKUP formula between 2 tables

Re: Change Rich text field to Multiline text field - so can export to excel with code

Re: Get value present in a field before the trigger of the same field

Re: Can I replicate Access key fields, indexes, enforced relationship integrity, and data entry options in Ninox

Overview