"Advanced" section not available for action

AppSheet AppSheet Q&A
,
1

I am trying to use the INPUT functionality and I am looking for the advanced section of a task (“Data: add a new to another table using values from this row”). However, here are no action properties (only display, behavior and documentation).

Update: I noticed that the advanced section is only available for “Set the values of some columns in this row”. How can I achieve an action to add another row and also use INPUT?

I found this relating question which assumed that the feature is still in role out (but more than 16 months ago): https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Can-t-find-quot-Advanced-quot-section-in-Action-properties/m-p/643178

I also tried to enable beta features.

2

There is an action type of “add a new row to another table using values from this row”. It operates in the context of an existing row allowing values to be grabbed and applied to a new row in a different table.

3

INPUT() is not available with the add new row action.

4

How can I achieve INPUT with “Data: add a new to another table using values from this row” then?
My idea at the moment to make separate actions and combine them:

  1. Update values of this row with INPUT by setting the INPUT to a temporary variable
  2. Add to another table with values from this row
  3. Clear temporary variable

The annoying thing is that the temporary variable is then visible to the user, plus the procedure is quite cumbersome. Any better ideas?

5

INPUT is a good function to improve the UX.

But, if you are disposed to put in higher level the funcionality. You can use the following app action:

Go to another view within this app: LINKTOFORM(form-view-name, [column-name1, column-value1, column-name2, column-value2, …], [app-id: TEXT])

This way you can add a new row to another table, using any variable data for each column of the launched oppened form.

6

I have a similar situation - but I don’t want to be in the context of an existing row - basically, I would like to have a way to add a suggestion for the current view (regardless of context) in a “Suggestions” table from my users without resorting to opening up a full form to add the suggestion - I like the “Input” functionality as a pop up.