-1 from table field value upon submission?

[hominid4]

I've created a Fabrik list that consists of:

- Member User ID: {membertable___member_user_id}
- Member Entry Code: {membertable___member_entry_code}
- Member Session Count: {membertable___member_session_count}

{membertable___member_session_count} will equal "12".

How to "{membertable___member_session_count} - 1" each time form is submitted?

A computer will be at the front desk of an exercise gym with this form, containing the Entry Code field only and submit button; User ID is hidden. Each time a member enters their Entry Code a pop-up shows and says "Thank you, you have X Sessions left".

My question is, when a member enters their Entry Code and submits the form, how can the submission minus 1 Session each time the form is submitted?

Thanks!,
Wesley

 

[cheesegrits]

Try using a calc element for membertable___member_session_count. Set the "default" to 12. Set "Calc on save only" to Yes. Use the PHP:

return (int)'{membertable___member_session_count}' - 1;

-- hugh

 

[hominid4]

Jeez that was easy! Thanks, just what I needed.