Help!! App formula? I hv 2 table "Status" & ...

[Abu_Md_Moniruzj]

Help!! App formula?

I hv 2 table “Status” & “Outgoing register”. Table status is uptable & outgoing is addable. Both these table hv same colums Employee & Return time. Outgoing table Employee is reference from Status table Employe.

I want when an specific employee add their outgoing register and fill Return time, the ‘Status’ table ‘Return time’ column

will be automaticall updatd for that specific employee’s ‘return time’

collumn. Keep in mind that the latest return time added by the employee in ‘outgoing registrar’

will b updated in Status table return column.

What will be the app formula for Status table return time column? Urgent, pls!!!

[Sdfaheemuddin]

Use MAXROW with filter for useremail

[Abu_Md_Moniruzj]

@Sdfaheemuddin Formula/expression

pls brother!!

[Abu_Md_Moniruzj]

@Sdfaheemuddin In which table i will get the result?

[Abu_Md_Moniruzj]

Now its showing value in test. But don’t get the result in Status table!!

[Abu_Md_Moniruzj]

@Suvrutt_Gurjar

I use this

=MAX(SELECT(Register[

লগ ইন ],[বহিরাগমনের সময় ]=[_THISROW].[বহিরাগমনের সময়]))

লগইন =

Timestamp & followed by the desired column Translate

[Sdfaheemuddin]

This formula is for Virtual column. Where are you using this formula?

[Abu_Md_Moniruzj]

@Sdfaheemuddin

Ok bro, now i m getting the result.

Its gives me the maxium duration of my desired column where as i want the most recent login duration…

How to fix it?

[Sdfaheemuddin]

@Abu_Md_Moniruzjaman

1. What is the key column of both the tables?

2. What is the type of column named return time / বহিরাগমনের সময়

3. Try this if বহিরাগমনের সময় is of type time/datetime and Employee is not key in status table

Max(Select(Outgoing register[বহিরাগমনের সময়], [Employee]=[_ThisRow].[Employee]))

4. If Employee is key in status column then Max(Select(Outgoing register[বহিরাগমনের সময়], [Employee]=[_ThisRow])) Translate

[Abu_Md_Moniruzj]

Great. Thnx… Its working now.

[Suvrutt_Gurjar]

Hi @Abu_Md_Moniruzjaman, The appformulacan look something like below in a virtual column [Return Time] in Status table

=MAX(SELECT(Outgoing Register[DateTimeStamp],[Employee

Column in Outgoing Register Table]=[_THISROW].[Employee Column in Status Table ]))

The expression assumes that the Status table has one row per employee

Outgoing register table references Status table.

[Abu_Md_Moniruzj]

@Suvrutt_Gurjar

Bro…

The expression is valid but does not bring any change.

[Sdfaheemuddin]

Try this Any(Select(Outgoing register[Return time],[]=MAXROW(“Outgoing register”, “Return time”,[Employee ID]=[_ThisRow].[Employee ID])))

[Abu_Md_Moniruzj]

@Suvrutt_Gurjar

I use this formula

=MAX(SELECT(Register[

লগ ইন ],[বহিরাগমনের সময় ]=[_THISROW].[বহিরাগমনের সময়]))

Here, Register is table name followed by timestamp column,

followed by the column exchange values each other… Is it ok??

No result…

Translate

[Abu_Md_Moniruzj]

@Sdfaheemuddin

Not working bro…

[Abu_Md_Moniruzj]

Emploee ID, is the ID column of the employee or specific employee name??

[Sdfaheemuddin]

Your reference column or anything which is common in both the tables

[Sdfaheemuddin]

In place of enter the name of you key column of Outgoing register