Fred

San Francisco, USA

3366
532
4

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

My Posts

Latest Posts

Re: Store generated PDFs
@Alina Morgovsky You could modify your GENERATE button in the first screenshot to create the new records. Do you need help with that code? Can you post the code you have so far that is not working?…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Store generated PDFs
You probably want to create a new table that stores just your printouts. From what I've seen on Nioxus' webinars is they don't link their document table to any other table.…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Importing QuickBooks transaction report to create tables in Ninox
Can you post a two record sample of your data? One record with out the split and one with?
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Problem Dynamic Print Layout - iteration
@gaetan if everything is working, please mark this post "Answered".
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Duplication when importing products
You are saying: if not existingRecord then doesn't work. You can try: let existingRecord := (select '3_Article' where 'Article No.' = articleNo); if count(existingRecord) = 0 then If that doesn't…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: In a dynamic print it is possible to format a number
You can also format in Ninox as you create your JSON, to make the coding easier on the Carbone side.
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: In a dynamic print it is possible to format a number
Yes, you can format numbers in Carbone. Looks like they can even do currency conversion for you. Don't know where they get their rates from, but kinda cool.
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Problem Dynamic Print Layout - iteration
Can you post a sample DB?
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Thoroughly delete image elements with code
@我是我的我 Well Ninox says: To fully clear the file reference from an Image field, you need to manually set that Image field to null using scripting, such as: removeFile(Image); Image := null;…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Problem Dynamic Print Layout - iteration
@gaetan That is the Ninox code to make the JSON. Put this code in a formula field in the same table as the dynamic print and copy a bit of the actual JSON code that is produce.
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Problem Dynamic Print Layout - iteration
If your doc that just has {d.geo[i].ID} {d.geo[i+1]} Does anything print? In your table Cadastre is there another reference field called Cadastre? I ask because your Ninox code has that structure.…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Who has set up email sending via SMTP in Ninox? Please share your experience!
Ninox, cloud version only, does have email capabilities it is called sendEmail().
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: real time link between local DB and Cloud DB
If you have a public cloud account, you can access your DBs through the app. Once you login in the app you will see your cloud workspaces. You can then interact with your DB in the app.…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: How to filter selection in dynamic choice field according to selection in another choice field.
@Michal Bor said: I have tried to make it again, but still does not make record of NAME and SHOP if I add relationship between tables. It is confusing at first. Learning any new language is.…
- Fred
- 1 mth ago
- 1
- Get help
- Reported - view
Re: real time link between local DB and Cloud DB
Is there a reason why you can't use the cloud DB in the app? If you have to use an offline DB, one way would be create a button that exports the updated records then emails them to a gmail account…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: copy part of a table on a new subtable
If Pacientes is name of the reference field in Cirugias then linking them in with the loop variable should work. I know something using ‘this’ directly doesn’t work so you have to put ‘this’ in a…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: hide add record
@Leo Woer said: By the way - can I ask you about another item, which I am stuck with ? Of course, just start a new post.
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: How to download a copy of your DB.
If you have the Starter subscription level, you can use the MacOS app to download your DB. The MacOS app can download any level of subscription.
- Fred
- 1 mth ago
- Learn and Share
- Reported - view
Re: Select top 10 records from view
That is a very good question. The only other way would be if you can get the records you need in Website Support through a reference field. Can you post a picture of your data model?…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: hide add record
Do you want a table like view of some specific data to present? Do you want people to be able to make a choice? What do you exactly want this new feature to do?
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Address split into separate fields
So I tried using U Man Genius' Ninox ChatGPT for this and this is what it recommended: function getCity(address : text) do "Extracting the city name"; var parts := split(address, ", "); var location :…
- Fred
- 1 mth ago
- Get help
- Reported - view
Re: Verknüpfte Tabelle: Kachel Ansicht
I would think you could use html tables, urlof(), and an image file to be a button. Take a look at@Sotirios Zormpas great post.
- Fred
- 1 mth ago
- Learn and Share
- Reported - view
Re: Relations between records in the same table
Since all of the data is the same it would make sense to have one table. I have made a test DB to show how it could look. Open the OneTable table to see how it works.…
Attachment
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Address split into separate fields
You might have to make the following change to the Address field: let regexCode := "(.*?)" + City + ","; extractx(firstStep, regexCode, "i", "$1") I found this address:…
- Fred
- 2 mths ago
- Get help
- Reported - view
Re: Address split into separate fields
If this is for a business then there are companies that can provide you with a csv that you can import. Or even better maybe through API you can get the data.…
Attachment
- Fred
- 2 mths ago
- Get help
- Reported - view

1 2 3 4 5 135

Welcome to the Ninox community

Fred

My Posts

Re: Store generated PDFs

Re: Store generated PDFs

Re: Importing QuickBooks transaction report to create tables in Ninox

Re: Problem Dynamic Print Layout - iteration

Re: Duplication when importing products

Re: In a dynamic print it is possible to format a number

Re: In a dynamic print it is possible to format a number

Re: Problem Dynamic Print Layout - iteration

Re: Thoroughly delete image elements with code

Re: Problem Dynamic Print Layout - iteration

Re: Problem Dynamic Print Layout - iteration

Re: Who has set up email sending via SMTP in Ninox? Please share your experience!

Re: real time link between local DB and Cloud DB

Re: How to filter selection in dynamic choice field according to selection in another choice field.

Re: real time link between local DB and Cloud DB

Re: copy part of a table on a new subtable

Re: hide add record

Re: How to download a copy of your DB.

Re: Select top 10 records from view

Re: hide add record

Re: Address split into separate fields

Re: Verknüpfte Tabelle: Kachel Ansicht

Re: Relations between records in the same table

Re: Address split into separate fields

Re: Address split into separate fields

Overview