My Goal is to show a popup form when an user clicks to an input button. I have created a reference view for the popup form and want to reference to the another form.
Below are some screenshots that can help you to understand the context of the problem.
a) The first screenshot show the preview of the AssetDetails Form. I want to put the inline form in the Asset ID input section.
b) The second screenshot show the App Formula for the Asset ID. In this formula, i am linked the view to the Asset Search.
c) The third screenshot represents the view of the asset search. Note: both of this views (Asset Search and Asset Details) are linked to different Data sets. Asset Search â Assets and Asset Details Form â Asset Details.
Start by creating a form view for the Asset Search table. Ensure you have a form view created for the Assets table. In UX > Views, create a new form view if it doesnât exist and name it Asset Search.
Next, in the Asset ID column of your AssetDetails table, use the LINKTOFORM function instead of LINKTOVIEW to directly open the form view. Update the formula to:
LINKTOFORM(âAsset Searchâ, âAsset IDâ, [_THISROW].[Asset ID])
Ensure that the Asset ID column in the AssetDetails table is of type Ref and specify the source table as Assets.
Verify that both views are correctly linked. Make sure the Asset Search form view correctly points to the Assets table, and the AssetDetails form view correctly points to the AssetDetails table.
Then, set up an action to open the form. Go to Behavior > Actions and create a new action for the AssetDetails table. Name it Open Asset Search, configure it to be triggered for a record of this table, and use App: go to another view within this app for the action. The target field should contain:
LINKTOFORM(âAsset Searchâ, âAsset IDâ, [Asset ID])
Next, add this action button to the AssetDetails form view. Go to UX > Views, select the AssetDetails form view, and in the Behavior section, add the Open Asset Search action as an inline button.
1 Like
For the Asset Details Table, I selected the Asset ID type âRefâ. However, an error occurs: âThe expression is valid, but its result type âAppâ is not one of the expected types: Refâ
1 Like
To resolve the issue with the error message âThe expression is valid, but its result type âAppâ is not one of the expected types: Ref,â you need to ensure that the Asset ID column in the AssetDetails table is correctly set up as a reference (Ref) type and handle the navigation separately through actions.
First, make sure the Asset ID column in the AssetDetails table is set to type âRefâ and references the Assets table. Go to Data > Columns, select the AssetDetails table, and confirm that the Asset ID column is configured as a reference to the Assets table.
Next, ensure there is a form view for the Assets table named âAsset Searchâ. Go to UX > Views and verify this. If it does not exist, create it to facilitate the navigation.
Then, create a new action specifically for navigation. Go to Behavior > Actions and create an action for the AssetDetails table named Open Asset Search. Configure this action to perform the âApp: go to another view within this appâ behavior. Set the target to:
LINKTOFORM(âAsset Searchâ, âAsset IDâ, [Asset ID])
This action ensures that when triggered, it opens the Asset Search form with the correct Asset ID.
Finally, add this action to the AssetDetails form view. Go to UX > Views, select the AssetDetails form view, and add the Open Asset Search action as an inline button or as a form button in the Behavior section.
By separating the navigation logic from the column configuration, you avoid the error and correctly set up the Asset ID column as a reference. This method maintains the integrity of your data structure while allowing users to navigate to the Asset Search form view easily by clicking a button. This approach ensures that the Asset ID column functions properly as a reference, and the user interface remains intuitive and user-friendly.
