I have a form where the student can be marked as Paid by Cash, Online, or Waiver.
Iโve created a slice that shows that student and ONLY the paid fields, so the Payment Edit for is nice and short.
This allows me to have an Action called Accept Payment that opens a nice short form with just the payment data in it.
The problem is that when I save the form, itโs trying to add a record not update an existing one.
Im getting an error that says โThere is already a row that the key โxyzโโ โฆ
How can I get the form to update rather than insert?
Thanks again โฆ
#SOLVED!
@David_Hopkins You could make your action use a deep link like this: LINKTOFORM(โyour row idโ, โYour Form Viewโ)
@tony Actually, thats how i get to where im atโฆ
Soโฆ
Students table (paid, receipt number) where paid can be cash or online and if online receipt number is required. But students table has 20 other fields as wellโฆ
I created a slice of the students table with just the key, name, paid and receipt number fields. so the Form for it is Name, Paid and Receipt Number. perfect.
Using the LINKTOFORM(sliceformname, [key]) i am able to bring up exactly what I wantโฆ a simple form with Name Paid and Receipt โฆ
Trouble is, when saving that form, i get the notice that โa record with this key already existsโ โฆ soโฆ for some reason it seems that the slice is trying to insert rather than update.
The Slice is set to UPDATE only .
hope that adds some clarity.
@David_Hopkins Sorry. I misspoke. Try LINKTOROW([key], โsliceformnameโ) instead.
(LINKTOFORM is used to add a new record, using the provided default values)
@tony OHโฆ that looks like it could itโฆ
checking.
@tony OUTSTANDING Tonyโฆ Great Callโฆ that did exactly what I wantedโฆ
on a side noteโฆ
I was using this . โ
LINKTOROW([Name], โPayment Formโ, [_appname])
โ but couldnt get [_appname] to workโฆ suggestions?
@David_Hopkins The [_appname] syntax only works in workflow templates, unfortunately. Youโll have to hard-code the app name. Glad you got it working, though.
@David_Hopkins Also, if youโre linking to a row in the same app, you donโt need to include the app name in the LINKTOROW formula.
User | Count |
---|---|
41 | |
31 | |
29 | |
16 | |
14 |