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

references
(Abu Md. Moniruzjaman) #1

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!!!

(Syed Faheemuddin) #2

Use MAXROW with filter for useremail

(Abu Md. Moniruzjaman) #3

@Sdfaheemuddin Formula/expression

pls brother!!

(Abu Md. Moniruzjaman) #4

@Sdfaheemuddin In which table i will get the result?

(Abu Md. Moniruzjaman) #5

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

(Abu Md. Moniruzjaman) #6

@Suvrutt_Gurjar

I use this

=MAX(SELECT(Register[

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

লগইন =

Timestamp & followed by the desired column Translate

(Syed Faheemuddin) #7

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

(Abu Md. Moniruzjaman) #8

@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?

(Syed Faheemuddin) #9

@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]))

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

Great. Thnx… Its working now.

(Suvrutt Gurjar) #11

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. Moniruzjaman) #12

@Suvrutt_Gurjar

Bro…

The expression is valid but does not bring any change.

(Syed Faheemuddin) #13

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

(Abu Md. Moniruzjaman) #14

@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. Moniruzjaman) #15

@Sdfaheemuddin

Not working bro…

(Abu Md. Moniruzjaman) #16

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

(Syed Faheemuddin) #17

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

(Syed Faheemuddin) #18

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