Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3373
533
4

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

My Posts

Latest Posts

Re: Duplicate some fields in a final summary ? How to do ?
Hi Fabien - Is your form in one table and the final summary fields in another? Do you need to create a new record in the final summary table first?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Is there a way to enter text field value from a list of 'acceptable' values in a listbox
If the Provider field in Payments is a reference field to Providers then it will default to Popup and show you all the records in Providers. If you edit the Provider reference field in Payments you…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two bases Ninox side by side on an ipad ?
Since you use iCloud you can not open two instances of Ninox. If you look at the product page for Ninox it describes the different offerrings.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Two bases Ninox side by side on an ipad ?
If you use iCloud for storage then no. If you use the cloud then yes, but not through the Ninox app. You will have to open one db in the a browser then the other in Ninox app.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sales Tax Issue
In a formula on a field in your Invoice Table you can do something like: let curRec := this; let xTax := (select 'Purchased Items' where Invoices = curRec and 'sales tax' = 1);…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: user id
Can you describe what you want to happen, with table and field names?
- Fred
- 3 yrs ago
- Learn and Share
- Reported - view
Re: Help needed with invoicing
You reference an auto fill date code but didn't post it. Since you removed it have you had any issues? The other code you posted don't seem to touch any date fields so I don't see anything there.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Help needed with invoicing
Hi Michael - Do you have any trigger code or do you only notice this when you go to your Reports dashboard? What is the code you have in your Reports table view?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Dependant Table Actions
Hi Andrew - How are your TableA and TableB related? That is a lot of things to do. Why don't we start with creating one record in Table C from Table A. First create a button in Table A,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bundled Product Circular Reference
You might have to consider making another table raw materials or something like that. Then you could make it a child of products. Then you can make a product that has many raw materials.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bundled Product Circular Reference
Can you post a sample of your code?
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Can I use two field contents as choices?
Dynamic choice fields are based on records in a table not on fields.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Re-reading my last comment and I am embarrassed that I wrote it. I am very sorry for it. you deserve to be treated with dignity.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
You made Noms(colonne14) = 0. So what do you think would happen when you did that? Just change everything back. I was talking about changing the Formule doublons Noms,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
What did you change? Just change whatever you just did back.
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
If Noms = Colonne14 then why not just use Colonne14? With troubleshooting you need to go back to the simplest form. Verify that you using the raw data and not other formula fields.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Well I am now confused. But at least on the coding front you need to double check your coding. For the Nom formula you sill have the := in line 2. Now you say you have two formulas,…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
can you post, again, the final code for "Formule doublons noms".
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Wow, maybe I need to stop posting. Another mistake of mine. In Line 2, I was wrong to say you need a colon in front of the equal sign. It should read: if myV = null then The second image it looks…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: create records in a subtable
Oops, sorry. My bad. I did not take into account the For loop myself. :) You can skip the curRec variable. for d in (select Heste where Kategori = 2 and Lokation = 1) order by ID do let p :…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: create records in a subtable
You are very close. You need to put the create code inside the for loop. Then you just need to add a variable that gathers the data for your current record.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Also just noticed in line 2 you have a capital "I" for if. That has be lowercase "i". You also need a colon in front of the equal sign. if myV := null then
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Remember that all Ninox code has to be in English. Table/Field names can be in any language. Any text that is output can be in any language. let myV := Nom ;…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
It took me awhile to figure it out, but I think you are seeing duplicates on empty cells because you are not checking for empty fields first. Even empty cells satisfy your current conditions.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Bigger or equal…
Just switch the symbols around >= or <= NOT => or =<.
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 127 128 129 130 131 135

Back to top

Overview

View all topics