Skip to main content
Privacy
Contact
How to enable Javascript
Sign Up
Log in
Welcome to the Ninox community
Search all topics or
ask a question
Learn and share
Get help
Service status
Documentation
Setup
Databases
Automation
My account
Administration
Webinars
Overview
Profile
Fred
Fred
San Francisco, USA
3418
539
4
Joined: Thu Feb 06 18:42:57 UTC 2020
Follow
My Posts
Latest Posts
Re: Tables sync
@pirinisz said: Yes but in a formula there is no grading by date I have no idea what "no grading" by date means? Since the date field in Table A is a date field.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: Sorry man, the date field is actually a simple date field, not a reference. Refer back to my original reply about creating a formula field as your Date field for Table B.
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: On Table B I have 2 references (one for name and one for date) Are your two reference fields pointing to Table A?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: OK but I don't get to see the date field this way.... I thought you were going to use a formula field? Another way is, you can add the date to the Show data as formula:…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: I added in the "trigger after update" the following code: if today() > 'date' then 'date' := date(year(today()) + 1, month('date'), day('date')) end Ninox has pretty nice date data…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: Could you please explain to me with more details the following, according to the values I gave you? In Table B, open Edit Fields. On the right side of the window is a section called…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: But I noticed that I have to close and reopen NINOX in order to synchronise, right? Which version are you using, cloud or MacOS app?
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
@pirinisz said: After that, I will have to change some values on field Y (dates) in Table A. How will I change the links to field Y on table B automatically??? If you set it up,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Proper Case code sample
what about the length function? let desLength := length(DESCRIPTION) DESCRIPTION := upper(substring(DESCRIPTION, 0, 1)) + lower(substring(DESCRIPTION, 1,…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Tables sync
I can’t tell if your “links of X and Y” are regular fields or reference fields. Ninox does linking of records differently than other DB apps. It links at the record level.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini said: One thing I'm struggling with in my own syncing implementation is I'd really like to generate an array of IDs for Items NOT checked off in the Dynamic Multiple Choice field.…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy Yes/No function value
@ekalcasino777 said: it seems to me that the best solution for us is to simply copy all the table data "GM TABLE" the next day. Do not copy it partially, but the all table.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Send email and include only fields with value
Since fields are involved, I don't think there is any easy way around using a bunch of if statements. Then you will have to play around with formatting,…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
Ok, here is the updated DB. It was an interesting thought experiment. There is a new button called Modify Invoice and a new Yes/No field called modify. I also created a new dynamic multi choice (dMC)…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini said: Kent Signorini How would you handle a Synchronize rather than an Add? (Including leaving the adjusted Quantities in the table for items.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@Kent Signorini It is not actually too "bizarre". On the cloud version, those triggers happen on the server side. Where the server is the "user" doing the action.…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini said: Fred Yeah, looks like the key is using [ ] rather than the where clause. this works for me too: select Items where 'In Stock' I just stay away from use "where" since you can…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
@Kent Signorini said: By the way, is there any way to further filter the items shown on the Multiple Choice? I tried "select items where..." (assuming there are other fields to categorize the items)…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
Here is what it could look like. I would say it could be easier for user with a dashboard as they don't have to see the whole table. I used @Jacques TUR code in the button so you can add all…
Attachment
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Structural Problem - How to choose multiple items to add to an Invoice?
Instead of working out of the Appointment table, use a dashboard. Which is just another table but allows you to control things better. You would then create a reference field to Appointments so users…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Copy Yes/No function value
@ekalcasino777 said: Fred I need to copy YES/NO button value in new day table "GM TABLE" I understand that. I'm trying to help you figure out the error. The error says it can't find 'GM Table'.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
@Kent Signorini said: So I'm trying to write some code to do this for multiple fields. Take a look at this post and see how you can create it without using a bunch of if statements.…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Determine if linked record's Multiple Choice contains value from this record's Choice field
Once you start working with multiple choice fields (regular or dynamic) then you can't use the equal sign so easily. Once a record has both options (cat and dog) selected then the field now has two…
Fred
Fred
2 yrs ago
Get help
Reported - view
Re: Two Serious Problems... Required Fields & Trigger on new record/update
Food for thought. Another way to do this is to take control using Dashboards. You can create a dashboard that users use to input data then before you create the new record you can check for any…
Fred
Fred
2 yrs ago
1
Get help
Reported - view
Re: Copy Yes/No function value
@ekalcasino777 said: Field not found: GM TABLE at line 23, column 22 not record id at line 23, column 29 Expression does noreturn a record: в фе line 25,…
Fred
Fred
2 yrs ago
Get help
Reported - view
1
86
87
88
89
90
137
Ninox-Website
Overview
Learn and share
Get help
Service status
Documentation
Setup
Installed apps
Public Cloud
Private Cloud
On-Premises
Databases
Tables
Table relationships
Fields and elements
Pages
Views
Import and export
Modules
Printing
Templates
Use cases
Automation
Scripting
Functions
API
My account
Subscriptions
Administration
Manage workspaces
Manage collaborators
Access permissions
Usage overview
Process monitor
View all topics
