Solved: Call form response from current submission - Page 2

Behram_BASHIR · 06-19-2020 06:15 PM

Hi all,

I am pretty new to AppSheet. Please excuse me if this is a well known issue, I have spent some hours trying to search the community form. I have a feeling I am not using the correct keywords.

I am trying a make a form which will pre-fill some responses as the “prefered” value based on the user. But these responses need to be editable…so dereferences method does not work (at least I have not been able to make the response editable when using dereferences).

Is there a way to pull selected responses before the form has been submitted? I.E on another platform that I am using, there are these microflows which allow you to execute certain actions when a field has been edited…is there something like that in AppSheet?

Could someone please point me in the right direction?

Steve

If the user is filling out a form for Parent_Table:

Assuming User is a Ref to Users, to auto-fill User_Office from User, set the Initial value expression for User_Office to:
```
[User].[User_Office]
```
Assuming User_Office is then a Ref to Offices, to auto-fill User_State:
```
[User_Office].[State]
```
And for User_Country:
```
[User_Office].[Country]
```

View solution in original post