How do you search through a spreadsheet data (on the website) while using an IFRAME to direct it to the website?
The IFRAME is set and the backend is fine but we are having trouble getting a search bar on the website we are using. We've tried a few different ways but none have worked so far.Here is the IFRAME:
<iframe id="frame" src="https://docs.google.com/spreadsheets/d/e/2PACX-1vSxBHuFxDbzN7A5PGfIv5_6anZOexY70erl4Z2QOKunCE1EHpZRCGwxVI3dTu9fUT4lQWzRAir_0_tB/pubhtml?gid=513199022&single=true&widget=true&headers=false&chrome=false">
</iframe>
See also questions close to this topic
-
Express not recognizing correct request body from Postman on PUT request
I'm working on an extremely simple CRUD backend using Express and MongoDB. It doesn't even have a frontend and I'm just using Postman to verify that each request is working as expected. Here's what my single-page app looks like so far:
server.js
const express = require('express') const bodyParser = require('body-parser') const MongoClient = require('mongodb').MongoClient let ObjectId = require('mongodb').ObjectId; const app = express() const uri = 'mongodb+srv://<USER>:<PW>@<REDACTED>.mongodb.net/test?retryWrites=true' let db MongoClient.connect(uri, { useNewUrlParser: true }, (err, client) => { if (err) return console.log(err) db = client.db(<COLLECTION_NAME>) app.listen(3000, () => { console.log('Listening on port 3000') }) }) app.put('/todo', (req, res) => { db.collection('todo').updateOne({_id: ObjectId(req.body.id)}, { $set: {item: req.body.value} }, (err, result) => { if (err) return console.log(err) res.send('Todo updated') }) })
I've already populated my cluster's collection in MongoDB Atlas using a POST request (not shown) that works. Here is what I've been trying in Postman after running the server locally:
The id of the existing Todo is well-defined in the Atlas cluster, but when I log the value of
req.body.value
in the first line of the callback function of the PUT request in server.js, it's showing the existing value that's in the Todo in that cluster, not what's actually being supplied via Postman. Why is the request body from Postman not being recognized for this request? -
Save Information about pressed Menu Item
I have a simple menu which should highlight the active menu item. I attached a photo of this below. The problem is that on a page load the entire site gets reloaded and I lose the information about which menu item was clicked. To solve this, I am saving the id of the element that was clicked in the
local storage
and read it on every page load. This works perfectly if the user has only one tab open at the same time. However, lets say that the user opens a second tab, then the second tab will overwrite the values from the other tab as well. Therefore if tab 1 stays on the same page and just reloads the page, it will highlight the menu item of whatever the second tab pressed.How would I solve this issue? Or to be precise, what is the best way in highlighting the active navigation item?
I am using
Asp.Net MVC
by the way. -
Problem with submitting form in JSF+PrimeFaces after using widgetvar
I am using widgetVar to enable a command button through javascript on some event. However after enabling command button, when I click the button, the form is not submitted and action is not called on server side.
The same setup works fine if I don's use widgetVar and keep button enabled by default. It submits the funciton, calls the actions and displays the result.
FYI, I am using ajax call.
<p:commandButton id="btnSearch" value="Search" disabled="true" widgetVar="searchButton" ajax="true" action="#{someBean.someFunction(someBean.firstName, someBean.lastName)}"> <p:ajax execute="firstName lastName" render="tabViewId:resultsDataTableId" onsuccess="showSearchResults()"/> </p:commandButton>
Javascript -
function onSomeEvent(){ PF('searchButton').enable(); }
Please advice.
-
How can I create a unique link that auto-fills a form in php?
I have a .php web form that I would like to append a string from a sql database to the url that can be clicked that is associated with the sql string. Any help would be greatly appreciated!
-
Send multiple values from one HTML page to another HTML page using javascript
I have an html (person.html) page which takes in a firstname, lastname, and address. I am redirecting to another page called processed.html. I am using the method="get" to send the information over in the URL. I am trying to display all of the information that the user entered on the processed.html page once they click the submit button. I am trying to write in Javascript in the processed.html page, but I cannot figure out how to extract all of the data, not just one piece. I will add some of the code below.
<!--person.html--> <form action="processed.html" method="get" onsubmit="return validateForm()"> <div id="part1"> <fieldset> <strong><h3>Billing Address</h3></strong> First name: <input type="text" name="firstName" required><br> Last name: <input type="text" name="lastName" required><br> Street address: <input type="text" name="streetAddress" required><br> </fieldset> <!--other info...--> <input type="submit" value="Submit">
I can't figure out how to get the information that the user entered to display on the processed.html page.
-
HTML Table overflow-y scrolling with fixed y axis headings
I have a table with headers for both the x and y axes, and want the table to scroll when it overflows on the y axis while retaining the header.
Using
display: block; overflow-y: auto;
in the<table>
element gives me some scrolling, but I lose the y axis labels.Here's a simple pen work-in-progress: https://codepen.io/Malgalin/pen/wNZRPz?editors=0100
I have also tried versions of making the
th[scope='row']
elements have a fixed position, which sort of works, but it creates messy over-lapping headers and makes the initial blank top left corner cell disappear.I'm happy to see answers using JS or jQuery if necessary.