Reference of Functions and Language

Hi, I understood the use of the select statement, but I need a confirmation, please... 1. I can use the select statement with a not linked table too, from any table in the DB? 2.…

how to project this db

Hello need to manage my small business. Every day X products goes out from my store to my clients, and Y products return (my client has not sold them all).…

Data Field Types

Hi, I'm trying to use this Db for the first time on a mini-Ipad, I'm trying to use the data field "location" but I cannot find any instruction on the on line help.…

Two search in a base

Hi Among others I have 2 fields in a base. -One with a cross inside sometimes (x) -Another one also with a cross inside sometimes (x) What should I do to find the both with their crosses displayed ?…

Change

How can change number to text. For example amount in invoice is 5000usd . I will see text too in down invoice. Five thousand dollars

Copy to Clibboard button

Can I create a button to select the contents of a field and copy them to Clipboard? (In FM Pro that was v straightforward)

• Answered

Text / Date Functions

I need to have a field that calculates 342 days added on to ‘breeding’ date entered in a table - So if someone enters 1/1/2016 for a breeding date I need the foaling date to show:…

Is it possible to link automatically (via a function) fields in two tables that contain the same text?

need help on importing a .csv into two related tables (scripting help?)

I have a ninox.com database with two working tables: Contacts (to track association members) and Events (to track events to which those members are invited).…

• Answered

Design Table for WBS

Hi One consultan, I have a Database with some tables, ones of them are correspond with the structure of the project WBS Work Breakdown Structure I have four level.…

• Answered

Formulas

Hello, When attempting to link entries together from two different tables via the cross reference function, Is there a way to get data entries to show up in the search results of "Find:…

Table References and Relations

Please provide a little more detail for your Person, Company, Employee example. What I specifically need is what you have to put in each table to tie them together,…

Account flows

In the Accounts table, I have a view called Flows with the following script. It gives the correct dataset but would like to filter out from that dataset the selected account ledger line items (that…

• Answered

Function and Language Reference

Is it possible to create views called "This Month" and "Last Month"? The same formula could be used for "This Year" and "Last Year" as well as "This Week" and "Last Week".…

Field labels in RED color

Hi, Just wanted to find out if it was possible to make the labels of the fields in RED color for all required fields in a table. eg: In the Sales Order table,…

• Answered

Bigger or equal…

Hi I have a formula in wich I should like to put the math symbol > or = I am on an Ipad and the virtual keyboard have not that possibility; just touch > or touch =;…