Manipulate spreadsheet through submission form?

1110 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi hopefully this is in the right place. I was wondering if there was a way to manipulate a field in a spreadsheet through a submission form. specifically number values. My office runs a reward ticket system where team leaders can award agents tickets. those agents can then spend those tickets on various items. So my main question is can I put a form together that a team leader would fill out to add tickets to an agents bank. Thank you in advance for any responses.

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

I’m not completely sure of what you’re asking, but hopefully this will help :grinning_face_with_big_eyes:

You could have an Awards table with the following fields:

  • ID (any unique identifier)
  • Number of Tickets (Number field)
  • Agent (linked to agent table)

Then you could have an Agent table with anything you need to include about each agent or as simple as:

  • Agent Name (Single line text field)

If you create a form view of the Awards table, you could share the form with team leaders where they could enter the numerical value of the tickets and select an agent (from the Agent table) to assign them to.

Does that help? Let me know if that doesn’t quite answer your question.