Hi,
have a simple expense tracking app. In a form view, Columns such as user, type, category amount etc. are filled. The resulting data is displayed in various relevant ways
Iโve constructed a deep link (linktoform) to another App if the โCategoryโ chosen/mentioned (I allow additional values in the Enum) is a particular value (โSitaram salaryโ for eg.) (which fills a form with a few values from the current form)
Deeplink:
LINKTOFORM(โSalary formโ,โChoose account:โ,โAastha & Adiโ, โAmountโ, if(isblank([_THISROW].[Amount (shared)]),[_THISROW].[Amount (shared)_13],[_THISROW].[Amount (shared)]),โComments:โ, if(isblank([_THISROW].[Comment (optional)]),[_THISROW].[Comment (optional)_14],[_THISROW].[Comment (optional)]))
I then created an action:
Go to another Appsheet app
if this condition is true:
and(contains([_THISROW].[Category],โSitaramโ),contains([_THISROW].[Category],โSalaryโ))
Need Confirmation?: On
Heres the question:
If I set my Form up to execute the above action to run on Form save. Will it go to the default view if above condition is not met? and conversely go to the deep link mentioned above if the condition IS met?
If not Could someone help me with the correct way to achieve this?
or an expression that can help?
TIA
best
Adi
In general, your requirement looks feasible, if the understanding is correct.
Understanding:
The LINKTOFORM() action is form save event action in app A. The action is to navigate to app B form with certain values in app B form being prefilled from app A form.
There is a precondition in app A such as say [Category] of the app A current row contains two certain values.
If the condition mentioned in 2 is not met, go to another view within app A
If so, we could discuss a possible way to achieve this.
Yes exactly
Okay, thank you.
LINKTOFORM( โForm name of App Bโ, [App A Column 1], " App B Column 1", [App A Column 2], โApp B Column 2โ, โฆ[App A Column N], โApp B Column Nโ, โApp B IDโ)
Condition for this action as you want below
AND(CONTAINS([_THISROW].[Category],โSitaramโ),CONATAINS([_THISROW].[Category],โSalaryโ)))
LINKTOVIEW(โView Name in App Aโ)
The condition for this action
NOT (AND(CONTAINS([_THISROW].[Category],โSitaramโ),CONATAINS([_THISROW].[Category],โSalaryโ))))
GoToAppBFormAction
GoWithinAppAView
Condition for this group action: TRUE
Please make this action as form save event action on form in App A that you wish to the elternate navigations after form save. Prominence of all actions โDo not displayโ
Please pay attention to syntax, especially the App B ID that you need to include in the first action.
Aaah I get hte concept
Thank you so so much! This is perfect
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |