Unfortunately, Importrange doesn’t trigger an app data refresh in the second app. You need some sort of app interaction that modifies or adds data to the second app to force the data refresh.
Could be anything. A form to fill out. An increment on a column in the user profile sheet. Just as long as it’s not a User Specific Column edit, it should refresh the data.
Do you have any idea on how to make it .
Because i make a changes in Apps A , lets say.
and i importrange from Apps A to Apps B.
As i now in Apps A. How to i can make let say increment at Apps B?
Open a glide table in one app than link that table into the other app than use single value columns in sheets that needs to be updated to copy values from that linked table… make sure when is time to refresh, some think like a button will write any value to that linked table… it have to be written to non user specific column. Than just one math column to do some calculation using any data in Google sheet with that single value column.
Or if you don’t need to have data in Google sheets… simply keep data in linked glide table
Best will be a increment. So it will change value and force math column to recalculate, it can also be a current date… anything that would be deferent value than previous one
You can try to put a trigger scripts in these two sheets to write current time, to force refresh by google and do some calculation with that time in linked glide table