Last modified data

[Benoit_Gramond]

Hi, I have an app for supply chain that I use to calculate the delivery dates and inform my customers if it changes.
I have a table with packings: APP_PACKINGS
I have a table with delays: APP_PACKINGS_DELAY

As I can have multiple delays for one packing, I must check the last modified delay (all the rows have a message in case people want to check why there is the problem). I tried 2 ways to do it:

1st Option:

LOOKUP(MAX(SELECT(app_packings_delay[date_add],
		[_THISROW].[as_id_packing] = [as_id_packing])),
	app_packings_delay,
  date_add,
  delay
)

2nd Option:

LOOKUP(MAXROW("app_packings_delay","date_add",
		([_THISROW].[as_id_packing] = [as_id_packing])),
	app_packings_delay,
  as_id_packing_delay,
  delay
)

1. What would be the best one in term of efficiency? I do not want my app to be delayed too much.
2. Is there a 3rd solution much simpler that would not involve 2 lookups in the same tale? (one to find the row then one to find the value)

Thanks a lot

[Steve]

For both of the options you presented, what happens if more than one app_packings_delay have the same date_add value?

[Benoit_Gramond]

@Steve it is a timestamp (datetime) so I hope it will not happen

[MultiTech]

I think option 2 is your best route.

In terms of efficiency, maxrow() is pretty efficient (especially over a select()) and lookup() is fast as well.

Where were you going to use this? A virtual column, in a workflow, a column value?

[Benoit_Gramond]

MultiTech_Visions:

Where were you going to use this? A virtual column, in a workflow, a column value?

I use it in a virtual column

[MultiTech]

Benoit_Gramond:

I use it in a virtual column

Just FYI, formula’s like this:

Benoit_Gramond:

LOOKUP(MAXROW(“app_packings_delay”,“date_add”, ([_THISROW].[as_id_packing] = [as_id_packing])), app_packings_delay, as_id_packing_delay, delay )

while being efficient, they can cause a slowdown during the sync process if you have a lot of data - the reason being is that for every row in the table with this formula, it’s running through that calculation.

Just something to keep in mind as your app collects more data, things like this start to become more and more costly. If you notice things getting slower you might consider moving that virtual column to an actual column, this way the data is stored instead of calculated on the fly.

[Benoit_Gramond]

MultiTech_Visions:

Just something to keep in mind as your app collects more data, things like this start to become more and more costly. If you notice things getting slower you might consider moving that virtual column to an actual column, this way the data is stored instead of calculated on the fly.

Indeed. in this case I would just use workflows to go and update the column when I had a delay. It would even be faster with a trigger in the database but there is no action to force the synchronozation of the app when it is done.

[MultiTech]

Benoit_Gramond:

but there is no action to force the synchronozation

It’s only recently really becoming widely used, but they’re actually is a way to force a sync.

Delayed Sync : Force App Sync with grouped action not working as intended Questions

I have a grouped execution of actions on a table for when a user submits a form. I would like to get an action that forces a sync because I have delayed sync enabled and realized that we are having some data loss from people closing their apps before the form was fully submitted. I have tried using the LINKTOROW()&"&at="&(NOW()+1) as seen on other posts but it does not work when it is part of a grouped sequence of actions. It will not force the app to update/sync and just continue on with the d…

[Steve]

MultiTech_Visions:

they’re actually is a way to force a sync.

But keep in mind: it’s still a sync, it takes time. Be judicious.

[Benoit_Gramond]

You are right indeed. It might not be the best solution yet.

[Benoit_Gramond]

Good to konw indeed. Thanks a lot !