Solved: LINKTOFORM or LINKTOFILTEREDVIEW

Chacal33 · 10-08-2021 01:04 AM

Hi all,

Can anyone help me figure out how to have an action button doing:
If data exists then LINKTOFILTEREDVIEW else LINKTOFORM?

Many thanks

Matt

bonameblisto

Third answer on your unformulated questiion after gooroo`s
What about next expression (?):
IF(ISBLANK([Data Field]), LINKTOFORM(…), LINKTOFILTEREDVIEW(…))

Read next, pls

For exmpl:

IF(
	ISBLANK([Data2]),
	LINKTOFORM("ForTests_Form","Data2",""),
	LINKTOFILTEREDVIEW("ForTests", [Data2] = [_THISROW].[Data2])
)

View solution in original post

Suvrutt_Gurjar

LINKTOFORM() is to be used when the user can/ needs to fill a new form and thereby create a new record based on certain fields from the existing record called say record A (in a detail/table view) be prefilled in the new record B form.

Both the record A and record B can be in the same table or in different tables.

Presume record A has fields [Name] with value John and [Surname] with value Doe, and [Office Address]with filled with 1, Office Road, Mars Town. Tapping the LINKTOFORM() action can take the user from detail /table view of record A to a new form (say record B) either in the same table or in different table with say [Name] and [Surname] fields prefilled in record B. The [name], [Surname] fields are prefilled in the new rcord with the help of LINKTOFORM(0 action construct.

LINKTOFILTERED() view can be used for navigating from a record in one table to another view with conditional filtering of records of another or the same table being presented in the new navigated view.

So if an existing record has an enum of [Natural Wonders] with options as “Oceans” and “Mountains”, and the user sets “Oceans” in the enum, the new navigated summary view may have records of “Ocean” names.

The descriptions of these actions in the article below explain the actions well

The sample app sare alos useful
https://www.appsheet.com/templates/This-app-shows-how-to-filter-your-data-using-a-form?appGuidString...

https://www.appsheet.com/templates/This-app-shows-how-to-link-to-a-form-and-fill-in-default-values?a...

Steve

To open one existing row in a form view:

bonameblisto

Third answer on your unformulated questiion after gooroo`s
What about next expression (?):
IF(ISBLANK([Data Field]), LINKTOFORM(…), LINKTOFILTEREDVIEW(…))