Hi everyone!
This app is made for flower industry
Not sure what is the best way to achieve my goal…
a little contextualization:
Variedad= flower type
Cama= Bed–>where the flowers are planted ( in one “cama/bed” can be planted diferent type of flowers)
Bloque=BLock= Group of beds
i have a table called “Entrada postcosecha” where all the flower that is cut each day related to the block and the bed is registered
i need to know on what date each variety began to be cut from each bed and block,
so i need to take the first row registered of each variety, bed and block (from table “entrada postcosecha” and print it on another sheet called “inicio de corte” where the date where the cutting of each variety began in each block and bed is stored
but i don´t know what can be the filtering condition for the main table “entrada postcosecha”
Thank you very much!
Your filter for the records for the minimum date could be
IN( [Key Column], MINROW(“entrada postcosecha”, “Date Column”, AND([Variedad]=[_THISROW].[Variedad] , [Cama]=[_THISROW].[Cama], [Bloque]=[_THISROW].[Bloque])))
Where [Key Column] is the key column of the table “entrada postcosecha”
You may need to add another argument such as maybe “month” or “week” or something similar if the table “entrada postcosecha” has all the historic records and you do this flower cutting activity on the same parameters of “Bloque” “Cama” and “Variedad” in periodic sequence.
Hi Suvrutt Gurjar,
thank you for your reply !!
for some reason the formula shows me an error in function IN()
Where are you trying this formula.
I’m trying this formula in a behavior
Okay thank you. Please try below. Please create a slice called say “entrada postcosecha slice”, on the "entrada postcosecha” table with the slice filter expression as below
[Key Column] =MINROW(“entrada postcosecha”, “Date Column”, AND([Variedad]=[_THISROW].[Variedad] , [Cama]=[_THISROW].[Cama], [Bloque]=[_THISROW].[Bloque]))
Now in the action behavior , please use following expression
entrada postcosecha slice[key column]
i don´t know what i´m doing wrong but still not working
[ID Postcosecha] = MINROW(“Entrada Postcosecha”, “Fecha Ingreso”, AND([Variedad]=[_THISROW].[Variedad] , [ID Cama]=[_THISROW].[ID Cama], [ID Bloque]=[_THISROW].[ID Bloque]))
which [ID Postcosecha] is my key column
this in order to create the cut start history in the “inicio de corte” sheet.
Oh okay. Thank you for all the details. We started the post with just the filtering condition, then action requirement, and finally BOTs . I think you may wish to change the post category to AppSheet Automation.
Your overall configuration looks good. Scheduled BOTS run only with the deployed apps. Is your app deployed?
Also can you please clarify in what way it is not working?
You may wish to check step by step as below
Is the slice returning expected records?
Is the reference action running just by tapping the action icon in one of the table records ( “Entrada Postcosecha” ) detail view and adding new records in the table “inicio de corte” ?
Is the BOT running in test mode, when you tap on the “Run” button in the Bot pane?
thank you for you patience Suvrutt
1.The slice is not returning anithing.
I think that’s where the problem is
Please test with a simple MINROW() expression such as
[ID Postcosecha] = MINROW(“Entrada Postcosecha”, “Fecha Ingreso”)
The above should return one row with Y in slice expression test
IS [Fecha Ingreso] a date or date time type column?
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |