I have 2 tables in one Data-set
1st (Records) : Data that can add and update
2nd (Dozen) : Data that can add and update too
I use expression of Select in 1st table to manage sell invoice of many kind of stuff
and if column A(categories) is filled in the form
it will automatically show list in columnB(sub-cate) which have "dozen" here
[I used or(SELECT(Records[sub-cate],[Categories]=[_THISROW].[Categories],FALSE),isblank())]
and I use action(add new raw to table) with bot(condition if Record(cate) is DOZEN)
this raw in RECORDS will add to DOZEN table
which columnC in records will add Text([date],"yyyymm") to columnC in DOZEN
Example:
If customer Alogen buy dozen of Sand bags online with me
and my reception fill form in table RECORDS
this raw will be
Customer: Alogen
ID : AALLDD
Column A : Construction
Column B : Dozen
Column C : Sand12free3
Column D : 15
then this raw will automatically add to DOZEN table
but Column C will be Sand12free3202305
Column ๐ง 15
Column E(take/get): 0
Column F(Left): 15
my 1st question is:::
if next time Alogan call me to take his 7 bags of sand
I try to make fill in the Column D in form_view automatically
if my client type id to AALLDD
and choose column C in DOZEN table
how to fill in column D automatically of the last quantity left after last times of every time he take
my 2nd question is:::
my raw will not add to table DOZEN
if I use formula in column C as
SELECT(DOZEN[columnC], [ID]=[_THISROW].[ID],FALSE)
with ENUM
for making it automatic filter only columnC that own by this ID
because there are many kind of dozen promotion I generate for marketing
but if I delete this formula
the action add new raw to another table is still function
(in my conclude opinion is : maybe the value of column C in action does not match with the formula of DOZEN table so I try to use formula OR(SELECT(DOZEN[columnC], [ID]=[_THISROW].[ID],FALSE), Any()))
but it still not work
Best regards,
and apologized for my poor-skill English
LinkedIn
Twitter
