Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: 3.10.6 weirdness
Well, don't know if Ninox did anything, but things are back to normal today.
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Variables
thinking about it, if you don't have a date then a "null" value will always return a false/else since you don't have anything to return a true value. What do you want to happen if there is no records…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Variables
@giuseppe said: The only thing I can't solve is that the formula, in leads where there are no appointments, always returns an "Update" value Can you post your new code?
- Fred
- 2 yrs ago
- Get help
- Reported - view
3.10.6 weirdness

So I checked by usage today and this is what I saw: The Cloud DBs workspace has only 1 DB and, when I last checked a few days ago, it was under 50GB and only 1 DB was displayed. I've opened a ticket.
- Fred
- 2 yrs ago
- 2replies
- 77
- Learn and share
Re: Variables
@giuseppe said: Unfortunately, it doesn't work well because Ninox returns me all Lead Update. According to your picture, you have a table view that could be from a reference field or view element.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: New here, could use some help with batch requests
@Pieter de Bruin said: I got a the emailaddresses from different files together into 1 file. Now I want to do a lookup for 5.000 - 10.000 persons if I have a personal business email and not the…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: 2 multiple choice creat records ?
It was quite an interesting task to figure out. You can put the following in a button to test it out: "takes the selections from the multiple choice fields and creates a string for each combination…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Variables
If Meetings is a reference field to the Meetings table and Quando is the name of the appointment field then you can try: let currentMeeting := last(Meetings order by Quando) if days('Data Ultima…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
@我是我的我 said: I saw the "loop1" command, Just to be clear it is a for loop command. "loop1" is just a variable name used in the for loop. "loop1" can be anything.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
Let us troubleshoot your original code as it can help in the future. You wrote in 程式 : let aa := table2; (select table3 where '数据表2' = aa).[number('选项')] This doesn't work since table3 is in a N:…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to write code to batch update data in two or more child tables?
Looking at your DB, first let us take a look at 程式. You can remove the select statement because you are only looking at related records. This makes the code much faster as your dataset grows up.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: double entries
If you are on public cloud or 3.10 of private cloud, you may want to consider creating Pages that users do all of their work in instead of letting them access to the raw data.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael Text is just a simple text field that has the list of country names, for me. It will vary in your DB. Can you post a sample of your DB?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael said: you can share this example. need to know what happend, everything's look fine This is what I have: let list := ( let x := split(Text, ","); for item in x do let i :…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Get the hours from an appointment as an Array
Interestingly, you can't get time data very easily in Ninox. You can get the start()/end()/duration() of an appointment field. Even with time fields, there is no command like month or day that will…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Split Function Help
@Rafael I don't think it is the code. I would check to make sure each data point has data and is in the correct format. What kind of field is Name? How does data get into the field?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Control panel data check
For a dashboard/page to work as data entry you need to have a button. In the code for the button you will put in checks to see if records or other data already exist.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Split Function Help
@Rafael If you are talking about the one I post with two fields, then yes. it works for me. When I add <br> it works too.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Double action button
In Ninox you use the semi-colon to separate commands: 'Fin de contrat' := 'Date Renouvellement'; 'Statut Bouton' := null
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Open Record based on UserName
@John Wilmans if you have any questions please start a new post.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Open Record based on UserName
May I suggest that you use your dashboard (or new pages) to show the data that you want to show, instead of pulling up the record and exposing your raw data to your end users.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: About code Questions
The problem is you put the old for loop inside another for loop and now Ninox takes the record you create and in the field 物流码 it copies each instance in the array "s" until it reaches the end so you…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@John Wilmans said: Do you know of anywhere that I can learn about how to do this better please? Do a search for Ninox Dashboards on the web and there are video links from Ninox and Nioxius.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael <br> is fine.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Split Function Help
@Rafael said: Yes works, but how can I do for include more fields Going off of my example this is how my code changes: let list := ( let x := split(Text, ","); for item in x do let i :…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view

1 68 69 70 71 72 154

Back to top

Overview

View all topics