Is it possible when create a record of an AppSheet App (name FirstApp) to "link" it to another record of another AppSheet App (name SecondApp), so that is possible to open the AppSheet record (of SecondApp) with a click action ?
Solved! Go to Solution.
You can create an action of type App: go to another view in this app and use LINKTOROW() in the action's Target expression. Note that, despite the name of the action type, you can target other apps. The LINKTOROW() help doc explains how.
My scenario is: i've an AppSheet where i have my Customers.
One other AppSheet (blank for now) where i have Orders, i'd like when create a new order link to a specific Custumer so that i can open the Customer from order
Is linktorow() useful in my scenario ?
Any more help please Steve ?
It would be, yes. But first, may I ask why you have two apps rather than one that includes both customers and orders?
Yes Steve, you're probably right.
In effect Customers and Orders are only an example.
In my real scenario i've actually 4 AppSheets App, to achieve specific tasks, they could have some common point, but also no, i've always think to improve - merge them somewhere.
So now in my main App i'd like to link the other 3 using LINKTOROW() that you've suggested ...
You can create an action of type App: go to another view in this app and use LINKTOROW() in the action's Target expression. Note that, despite the name of the action type, you can target other apps. The LINKTOROW() help doc explains how.
To go to a specific record of 1App from 2App i should previously have "copied" in 2App the uniqueID of record of 1App, is it correct ? Is it possible copy and paste the uniqueID from one App to another using an action button or whatelse ?
The "from" app needs to know the key column value of the row in the "to" app. Typically, a table in the "from" app contains those key column values. How it gets those values is entirely dependent on how your apps work.
@FaCe wrote:
i've always think to improve - merge them somewhere.
The key to making this work: Current User (Slice) | How to conform your app a... - Page 2 - Google Cloud Community
This technique will allow you to essentially build 4 apps in 1 - but with much less dev-overhead. You can restrict functionality, views, buttons - even records - based on the role of the user. Very handy.
@MultiTech thanks, i'm looking in that too ... in effect my 4 Apps have totally different views and other stuff, do you think it's possibile to merge them all using my actual database (Excel sheet) and having a sort of one initial view where select the 4 Apps merged ?
100%
Is it not possible to reuse (copy/past) the actual Database / Views and other stuff into one App ? Don't see explained in the link you've suggested ...
It is not possible to easily recreate portions of one app in another. The best you can do is copy the app's entire configuration to another or manually copy the configuration bit by bit. It's very tedious.
Hence why it's best to build in one app in the first place.
Something that should become the official position, imho.
@Steve wrote: copy the app's entire configuration to another
How to do that ?
My 3 little Apps (instead of the first one) have only 1 sheet so should be simple, at least lato database.
Hi Steve, sorry may you elaborate a bit how to proceed in details ?
When upgrade each of my 4 Apps i have a new version of each (and before it i've to create a copy?)
And then how to "merge" all 4 Apps into one ?
Thank you so much for your help
To "merge" the apps, you'll have to manually recreate the configuration from one app in the other. There's no easy way to do it.
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |