A google sheets script is not properly sending data to a separate google sheets file in mobile version
Budget: $10 – $30 USD
fix scripts so that whether using google sheets pc version or mobile version:
*timestamp script works properly
- the timestamp function in the longterm availability tab is currently messed up and adds the timestamp in the notes column instead of the timestamp column
*reset script properly clears data and resets formulas in the "submit availability" form
*submit script properly sends data to aggregate sheet and then resets the "submit availability" form
any incomplete info should remain in the "submit availability" form even after they click submit so that it is clear that this info has not actually been submitted and the user is able to quickly update any missing data (right now, any rows with missing data are just deleted and a non tech savy person might not even realize it)
*these scripts need to work quickly (my initial pc only version worked very quickly and only took half a second to perform the functions, but when i tried to change the code to work on mobile, it all slowed down tremendously and could take several minutes to send the data after clicking submit)
here is the current submission sheet (which has the scripts): https://docs.google.com/spreadsheets/d/1gW8P69rHm3oGZbzZRs5TWDBXmrVrn-bpNLgBNDBOglA/edit?usp=sharing
Additional Information
I have two google sheets- a submission form and an aggregate form. The user fills in required information in the submission form and selects "submit" from a dropdown menu to activate a script that sends the data to the aggregate form and then resets/clears the submission form. This needs to work on pc and on mobile google sheets versions but does not yet work properly.
Right now there are three separate scripts. One simply creates a time stamp. One deletes data and resets all formulas in the submission form. And one sends the data to the aggregate form. In an effort to make the scripts work on mobile, I seem to have messed up the timestamp and submit functions and in general made the scripts run too slowly to even work.
*timestamp script works properly
- the timestamp function in the longterm availability tab is currently messed up and adds the timestamp in the notes column instead of the timestamp column
*reset script properly clears data and resets formulas in the "submit availability" form
*submit script properly sends data to aggregate sheet and then resets the "submit availability" form
any incomplete info should remain in the "submit availability" form even after they click submit so that it is clear that this info has not actually been submitted and the user is able to quickly update any missing data (right now, any rows with missing data are just deleted and a non tech savy person might not even realize it)
*these scripts need to work quickly (my initial pc only version worked very quickly and only took half a second to perform the functions, but when i tried to change the code to work on mobile, it all slowed down tremendously and could take several minutes to send the data after clicking submit)
here is the current submission sheet (which has the scripts): https://docs.google.com/spreadsheets/d/1gW8P69rHm3oGZbzZRs5TWDBXmrVrn-bpNLgBNDBOglA/edit?usp=sharing
Additional Information
I have two google sheets- a submission form and an aggregate form. The user fills in required information in the submission form and selects "submit" from a dropdown menu to activate a script that sends the data to the aggregate form and then resets/clears the submission form. This needs to work on pc and on mobile google sheets versions but does not yet work properly.
Right now there are three separate scripts. One simply creates a time stamp. One deletes data and resets all formulas in the submission form. And one sends the data to the aggregate form. In an effort to make the scripts work on mobile, I seem to have messed up the timestamp and submit functions and in general made the scripts run too slowly to even work.