App reviews, troubleshooting, and recommendations
Hello!
My company hosts events in which competitors are required to fill out a form prior to adding product to cart.
I have this form written in the code and the information is then displayed in the orders sheet - we then take this information and manually enter it into our google spreadsheet
I am looking for an app to replace the form written in code that will automatically generate the data into the spreadsheet (or at least allow to export via excel)
Cheers
KSMGaming
What do you mean by "form written in code"? You can use Excel VBA for this purpose and a private Shopify app to get the required data, but I can offer you a better solution when you can tell what "form written in code" is.
as seen here
https://ksmgaming.com/collections/tournaments/products/december-13-trios-enforcer-7-0
in the product template, i have a coded in a simple form -> this information is displayed in the orders -> we then take this information and copy and paste it manually into excel.
i'm looking for an app to do this for us
form code example below
<form autocomplete="off">
<p class="cart-attribute__field">
<input type="hidden" name="attributes[Do you acknowledge you have read and agree to all KSMGaming rules]" value="No">
<input required class="required" type="checkbox" name="attributes[Do you acknowledge you have read and agree to all KSMGaming rules]" value="Yes"{% if cart.attributes["Do you acknowledge you have read and agree to all KSMGaming rules"] == "Yes" %} checked{% endif %}>
<label>Do you acknowledge you have read and agree to all KSMGaming rules</label>
</p>
<p class="cart-attribute__field">
<label for="email-address">Email Address</label>
<input required class="required" id="email-address" type="text" name="attributes[Email Address]" value="{{ cart.attributes["Email Address"] }}">
</p>
<p class="cart-attribute__field">
<label for="team-name">Team Name</label>
<input autocomplete="off" required class="product_field_required" id="team-name" type="text" name="attributes[Team Name]" value="{{ cart.attributes["Team Name"] }}" style="border:0px;">
</p>
<p class="cart-attribute__field">
<label for="activision-account-numbers-included">Activision Account (#numbers included)</label>
<input autocomplete="off" required class="required product_field_required" id="activision-account-numbers-included" type="text" name="attributes[Activision Account (#numbers included)]" value="{{ cart.attributes["Activision Account (#numbers included)"] }}">
</p>
<p class="cart-attribute__field">
<label for="kd-ratio">K/D Ratio </label>
<input autocomplete="off" required class="required product_field_required" id="kd-ratio" type="number" step="0.01" pattern="\s*-?[1-9]\d*(\.\d{1,2})?\s*" title="Number with two decimals" name="attributes[K/D Ratio ]" value="{{ cart.attributes["K/D Ratio "] }}">
</p>
<p class="cart-attribute__field">
<label for="stream-url-only-1-required-per-team">Stream URL (Only 1 required per team)</label>
<input autocomplete="off" id="stream-url-only-1-required-per-team" type="text" style="color:white" name="attributes[Stream URL (Only 1 required per team)]" value="{{ cart.attributes["Stream URL (Only 1 required per team)"] }}">
</p>
<p class="cart-attribute__field">
<label for="discord-name-check-in-member-required-only">Discord name (Check in member required only)</label>
<input autocomplete="off" id="discord-name-check-in-member-required-only" type="text" style="color:white" name="attributes[Discord name (Check in member required only)]" value="{{ cart.attributes["Discord name (Check in member required only)"] }}">
</p>
<p class="cart-attribute__field">
<label>Competing time</label><br>
<select required class="required" id="competing start-time? (Between 6am and midnight PST)" name="attributes[Competing time]">
<option value="1"{% if cart.attributes["Competing time"] == "1" %} selected{% endif %}>1</option>
<option value="2"{% if cart.attributes["Competing time"] == "2" %} selected{% endif %}>2</option>
<option value="3"{% if cart.attributes["Competing time"] == "3" %} selected{% endif %}>3</option>
<option value="4"{% if cart.attributes["Competing time"] == "4" %} selected{% endif %}>4</option>
<option value="5"{% if cart.attributes["Competing time"] == "5" %} selected{% endif %}>5</option>
<option value="6"{% if cart.attributes["Competing time"] == "6" %} selected{% endif %}>6</option>
<option value="7"{% if cart.attributes["Competing time"] == "7" %} selected{% endif %}>7</option>
<option value="8"{% if cart.attributes["Competing time"] == "8" %} selected{% endif %}>8</option>
<option value="9"{% if cart.attributes["Competing time"] == "9" %} selected{% endif %}>9</option>
<option value="10"{% if cart.attributes["Competing time"] == "10" %} selected{% endif %}>10</option>
<option value="11"{% if cart.attributes["Competing time"] == "11" %} selected{% endif %}>11</option>
<option value="12"{% if cart.attributes["Competing time"] == "12" %} selected{% endif %}>12</option>
</select>
</p>
<p class="cart-attribute__field">
<label>AM or PM</label><br>
<select required class="required" id="am-or-pm" name="attributes[AM or PM]">
<option value="AM"{% if cart.attributes["AM or PM"] == "AM" %} selected{% endif %}>AM</option>
<option value="PM"{% if cart.attributes["AM or PM"] == "PM" %} selected{% endif %}>PM</option>
</select>
</p>
<p class="cart-attribute__field">
<label for="time-zone">Time Zone</label>
<input required class="required" id="time-zone" type="text" name="attributes[Time Zone]" value="{{ cart.attributes["Time Zone"] }}">
</p>
<p class="cart-attribute__field">
<label>Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament.</label><br>
<input required class="required" type="radio" name="attributes[Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament.]" value="Yes"{% if cart.attributes["Do you acknowledge that KSMGaming is allowed to use any of your game footage played during our tournament."] == "Yes" %} checked{% endif %}> <span>Yes</span><br>
</p>
IF YOU ARE PAYING FOR MORE THAN 1 PERSON PLEASE FILL OUT BELOW
<p class="cart-attribute__field">
<label for="player-2-activision-account">Player 2 activision account</label>
<input id="player-2-activision-account" type="text" name="attributes[Player 2 activision account]" value="{{ cart.attributes["Player 2 activision account"] }}">
</p>
<p class="cart-attribute__field">
<label for="player-2-kd-ratio">Player 2 K/D Ratio</label>
<input id="player-2-kd-ratio" type="text" name="attributes[Player 2 K/D Ratio]" value="{{ cart.attributes["Player 2 K/D Ratio"] }}">
</p>
You're storing the details in cart attributes. Splendid. There's an specifically for for requirement - EZ Exporter ‑ Data Exports – Ecommerce Plugins for Online Stores – Shopify App Store
Shopify and our financial partners regularly review and update verification requiremen...
By Jacqui Mar 14, 2025Unlock the potential of marketing on your business growth with Shopify Academy's late...
By Shopify Mar 12, 2025Learn how to increase conversion rates in every stage of the customer journey by enroll...
By Shopify Mar 5, 2025