Skip to main content

Forum

Welcome to the Ninox community

Search all topics or ask a question

Badges

Latest Posts

Re: Formula issue
@pirinisz said: I found my error, instead of just typing, I was choosing the field from the list on the left of the code form, so instead of i.'θέση' the input was i.'θέσεις/καθήκοντα'.…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: How to Create Checklists / Tasks
@Smartin Your question deserves its own post. It sounds like more of a record creation process. Though you may want to rethink the checklist idea as having a checklist with hundreds or thousands of…
- Fred
- 2 yrs ago
- Learn and share
- Reported - view
Re: Formula issue
So when I type in: join(for i in 'Θέσεις/Καθήκοντα' do i.'Θέση' + " :" + i.'Οργανισμοί'.'Τίτλος' end, " ") I get: Is this what you want? You can modify the spacing around the colon. :)
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Formula issue
@pirinisz Can you take Steven's code an put in your table/fieldnames and post it? That will help us a lot.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz the file is fine. It will take a bit of time to wrap our heads around the field names and table names.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz While my Greek comes up to speed, can you tell us which tables/fields we should focus on?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz that is a good start. if you mouse over the top right corner of your DB you will see a down arrow. click on that then select Save as archive. then open do a reply and click on the paperclip…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz Can you upload a sample of your full DB? Save it as an archive then upload it here. We only need a sample data so you don't need to give us every record.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz don't worry, we don't judge. my data model for my main db is also a mess as it has grown organically as I've learned. If I redid everything it would be cleaner.
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Block a field if ?
@Rafael said: if the Document is 100% no charge more hour to a this Document. Could any of my first suggestions work? What is the relationship between FechaR5 and Horas Hombre?…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Formula issue
@pirinisz actually it would help to see the full DB since we need to see the formulas and relationships. Plus we will all learn a bit of Greek along the way. 😉
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Block a field if ?
What do you mean by “block the loading”? If Horas Hombre is a formula field then you can add an if statement that checks if FechaR5 is 100%. Or You can hide the field.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Ability to make field layout in form "static"
There are blank spaces you can use instead of empty text fields. If you are in Edit Fields, look under Layout fields. In terms of exact placement of fields, I don’t think that is possible in Ninox.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Sum related field with specific criteria issue
@Holly M When you get a chance can you post your solution so other people in the same situation can learn from what you did? Thanks,
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Iterate over DC
That is an interesting question. Why would you have a dC if there is only 1 choice? But let us solve the question. You can try this in a button: let x := (select dCTable); let y := item(x, 0);…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to Use Constraints
It took me awhile to get a feel for constraints as well. When you open the constraints window you see “a (Log)” and “b (Staff)” on the left side. Depending on the kind of field position is, Text,…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Convert "Credit Term" to Date plus credit term
You should be able to just do as I’m able to do modify a date field on the trigger after update on a number field: Due := Due + 'CREDIT TERM' Since Due is already a date field you don’t need to turn…
- Fred
- 2 yrs ago
- 1
- Get help
- Reported - view
Re: Birthday function in tab
If you want to modify text/number in a form then you have to use the styled() command. Check the link for a detailed list of options. You can put it in an if statement to check for if the month and…
- Fred
- 3 yrs ago
- 2
- Get help
- Reported - view
Re: Clear out Dynamic Multiple Choices
I’m unsure what you are asking about. You have a table with a dynamic multiple choice (dMC) field and when you create a new record it duplicates the selection made in the current record?…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Ninext : Debug Tracer
Thanks a lot for the warm wishes and the additions to Ninext. Hope you have a warm and sweet Christmas.
- Fred
- 3 yrs ago
- Learn and share
- Reported - view
Re: writable if - otherwise calculate from another field
@Rachel Brodie said: but if I enter numbers it reverts to “0” and there is no result in the inches field. I was trying “height_inches := height_cm / 2.54” in the inches field, which did not work.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Searching Multiple Choice Dynamic Fields
It is possible. You can look at this example to see how you need to get the data out of your dynamic multiple choice field. If you have further questions please post a sample of your code and some…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Sort / Order by based on total count
You can try: .... let x := for kurzspezifikation in kurzspezifikationen do first(stuecke[Kurzspezifikation = kurzspezifikation]) end x order by Kurzspezifikation I’m just modifying the last part…
- Fred
- 3 yrs ago
- 1
- Get help
- Reported - view
Re: writable if - otherwise calculate from another field
The one issue I see, if you use the writable if, then once you fill in a number in any field it will fill in the other field and now both fields are not writable.…
- Fred
- 3 yrs ago
- Get help
- Reported - view
Re: Start with date in a multi line test field
@J. Espí Next time please don’t put your non-code into the code blocks (the grey box). Just type your words in the white space. Put only code examples in the grey boxes.…
- Fred
- 3 yrs ago
- Get help
- Reported - view

1 96 97 98 99 100 153

Back to top

Overview

View all topics