I built an app that users fill out a simple form:
- User: Dropdown
- Date: Date
- Workout: Y/N
- Water: Number
- Money Spent: Number
- Read Book: Y/N
I'm using User and Date as the key.
I used the following for INITIAL VALUE for the columns to display the current entry when the user selects the User and Date that have data already:
If(AND(ISNOTBLANK([Date]),ISNOTBLANK([User])),
LOOKUP(
[_THISROW].[UniqueKey],
"Entry Table",
"UniqueKey",
"Workout"),"")
My issue is that when I user selects a date and user combo that already has data, when they save again it creates a new row instead of updating the existing row.
I basically want the form to be able to lookup any existing data based on User and Date combo (ALREADY DOING THIS)
THEN, allow the user to update any of that data, save again and update the row.
LinkedIn
Twitter
