Skip to main content

Welcome to the Ninox community

Search all topics or ask a question

Fred

Fred

San Francisco, USA

3418
539
4

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

My Posts

Latest Posts

Re: removing embedded quotes from a text object
@Sean said: I would recommend you turn off "Use smart quotes and dashes" if you haven't already. Good catch! Now I get: Weird. It would seem like it would either find the 2 double quotes or not…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: removing embedded quotes from a text object
Well that is very interesting @Sean . I checked and I'm running 3.7.14 now on both MacOS and iOS and I still can't get it to work. Though now I can type in the code with 4 double quotes and iOS will…
Attachment
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: removing embedded quotes from a text object
Well I the MacOS app and iPad react differently, which is just a sign that Ninox is not keeping the two apps in sync. If I put the following in a formula: replace(Test1, """",…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: Export child table
Do you mean you want to export a child table from the parent? You can always just go to the actual table and export the data.
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: removing embedded quotes from a text object
@Sean Can you make it work for double quote marks?
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: How to share active database with another user?
If you have the app version and do not pay a month fee then yes you are using iCloud as your file storage. That is how Ninox shares a DB file amongst Apple devices.…
- Fred
- 2 yrs ago
- Get help
- Reported - view
Re: removing embedded quotes from a text object
I’m guessing some javascript will be needed as Ninox doesn’t have a way of searching for quotes. It always thinks any quote mark is part of the code. You can search using regex,…
- Fred
- 2 yrs ago
- Get help
- Reported - view
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
- 2 yrs ago
- 2
- Get help
- Reported - view

1 80 81 82 83 84 137

Back to top

Overview

View all topics