hello,
i have table 1
with invoice nr, product, quantity
i want to copy selected records to another table using automations
i find the record, that meats the criteria (invoice nr) and want to “copy” those to another table
so i make triger, find recor...
Hello again, cannot move over this problem :frowning:
the situation:
Airtable
compare - Airtable
Explore the "compare" base on Airtable.
invoice comes, somebody writes to temp invoice 1 row = 1 ...
Hello again,
need to finish this and looking for the best and robust (and easiest) way to do it:
there is table product, which contains column price
there is table invoices, which contains invoice nr, shipping note nr, product (linked from the tlable...
hello, i am trying to do some basic count using formula (i think its basic).
there are 5 columns (named “name”,“rozmer1_cm”,“rozmer2_cm”,rozmer3_cm" and “vaha_kg”)
what i want to do is formula, which will get those results:
if all “rozmerX” < 50 and...
Hello community again :slightly_smiling_face:
i just want to ask for suggestion whats the best way to do this:
table 1 = products
some products are made from other products == spare parts, which can be sold separately. So they are in same table.
wh...
if “How to check or uncheck all 100 records in a view with one click ?” means select all record in view (records you want to see in view can be sorted by using filter), than it can be done by using the checkbox in 1st column:
which will bring this:
...
maybe mine imagination is bad,
but
it should be
IF december,“this”, if march, “this”,otherwiser “this”
IF(
{Financial End Year Date}=“December 31”, “8/15”&"/"&YEAR(NOW(),
IF(
{Financial End Year Date}=“March 31”, “11/15”&"/"&YEAR(NOW(), “4/30”&"/"&YE...
Thanks again for your patience.
I was trying it by myself and i was using (just dont know why :grinning_face_with_big_eyes: and please dont ask me:) ) the build of formula
IF OR rozmer AND vaha - now it seems so stupid to me,
i am writing this only...
ok, now i understand how to make nested IF…
but if i copy it and make new conditions :
IF(
AND(
{rozmer1} <= 50,
{rozmer2} <= 50,
{rozmer3} <= 50,
{vaha} * 1000 <= 250
),
“M1”,
IF(
AND(
{rozmer1} <= 50,
{rozmer2} <= 50,
{rozmer3} <= 50,
{vaha} * 1000...
Thanks for this - its nice, understandable, BUT…
BUT if i copy, it works - thats fine. If i add other conditions in this way…it works.
The truth is, i still dont understand those logic of this IF (but thats problem in mine head - time will make it be...
