For the following simple database example:
Table called EMPLOYER with the following fields:
EmployerName, Employees, Country.
Table called EMPLOYEES with the following fields:
EmployeeName, Employer, Country.
Required AirTable automation:
When EMPLOY...
Hi,
i created a table for Purchase Orders (POs), and a sub/child-table for the Order Lines (OLs).
Example:
PO-1
OL-1
OL-2
PO-2
OL-1
OL-2
Etc
What formulas or workaround do you recommend me to get a column at the OL table with the Order Line Number au...
That’s right, to build a user portal keeping airtable as a backend you’ll need a third party tool like miniextensions, softr, noloco (more expensive), or similar ones. In general they are not so user friendly like tally.
Hi Adam,
Many thanks for your help! :slightly_smiling_face:
I tried your solution above:
IF(
{Employee Country},
{Employee Country},
{Employer’s Country}
)
And it works well but it requires to “display” two fields on the table:
Employee Country (Ma...
Thanks Adam.
In most cases the EMPLOYEE is at the same country of the EMPLOYER, and so your solution would work for most of them by displaying the country in common.
However, we just want that the EMPLOYEE (child record), inherits the CountryName whe...