Hello I have the standart input-form with 3 inputs.
On the bottom right there is the button “ПОДТВЕРДИТЬ” (Submit). After entering values into inputs and clicking this button all data appends to the google spreadsheet, and inputs become cleared.
is there a way not to clear data in 2 first inputs after clicking button Submit?
and one more question - where can I turn off synchronization after clicking Submit?
Hi @Dmitriy_Rudakov
Dmitriy_Rudakov:
inputs become cleared
Dmitriy_Rudakov:
is there a way not to clear data in 2 first inputs after clicking button Submit?
Can you be more specific about that ? Do you mean that values just written in the Google Sheets disappear ?
Dmitriy_Rudakov:
where can I turn off synchronization after clicking Submit?
Here:
Thank you for sync, I will look))
No, I mean that after clicking on button Submit not to clear data in 2 form inputs. All data perfectly write to sheet))
@Dmitriy_Rudakov
Dmitriy_Rudakov:
No, I mean that after clicking on button Submit not to clear data in 2 form inputs. All data perfectly write to sheet))
ok.
Actually I think you have an option enabled in your form View options, which is probably currently ticked, unlike above:
You need to have in mind that this is a form supposed to get data from user input in order to append a new row to your sheet. Because of this, it’s naturally empty.
If you want it to be pre-filled with previous entry, you may want to use the Initial value expression of each of the fields expected to be pre-filled.
For building the expression for getting the last value previously entered, I suggest you have a look to this excellent thread (almost my bedside book):
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216) Tips & Tricks ?
Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…
More accurately, this post:
[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-ref-rows-and-select/24216/5) Tips & Tricks ?
How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()
LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” )
thank you for help! where must I put this formula? Sorry, I’m newbe at this))
I already checked this, but it is nothing displayed.
wrote in auto computed in initial value
LOOKUP(
MAX(
SELECT(
@packing[_ROWNUMBER],
([_THISROW].[login] = [login])
)
),
“@packing”,
“_ROWNUMBER”,
“login”
)
and no data showed
Seems obvious, but just in case: is there a data to show ?
You can see it with the Test button here:
About sync:
did you have a look to the first setting I shown here ?
[Don't clear data in inputs after clicking Submit](https://community.appsheet.com/t/dont-clear-data-in-inputs-after-clicking-submit/54914/2) Questions
Hi @Dmitriy_Rudakov Can you be more specific about that ? Do you mean that values just written in the Google Sheets disappear ? Here: [image]
you have to turn this one on (as it is in the image I provided)
but look. if I turn on delayed sync, the writing in spreadsheet is stopping to work(((
Actually no.
It will write, but a little slower.
You will know it’s written down as soon as the number in the red circle disappear.
Unless the behavior I’m describing is not the one you see ?
but it dissapear and writes to table only when I click on button Sync
it can’t write automatically after Submit?
There is a misunderstanding of the Delayed Sync feature.
I suggest you have a look to this documentation:
Section “Delayed sync”
Here is how it behaves on my apps (it’s a GIF - real time behavior, around 30 to 45 secondes on a complex app):
