Category: Microsoft
Category Archives: Microsoft
Upload a document to Assistant Vector Store
Hello,
I am new to Azure Open AI and looking for a way to upload document to Assistant Vector Store using REST API (HTTPs). I have a limitation and cannot use AzureOpenAI API as I would need to install DLLs in my system. The code should be something like below but I get “Resource not found” in response. Something is off. Please help. Thanks.
Hello,I am new to Azure Open AI and looking for a way to upload document to Assistant Vector Store using REST API (HTTPs). I have a limitation and cannot use AzureOpenAI API as I would need to install DLLs in my system. The code should be something like below but I get “Resource not found” in response. Something is off. Please help. Thanks. Dim apiKey As String = “myapikeyhere”Dim endpoint As String = “https://myresource.openai.azure.com” Using client As New HttpClient() client.DefaultRequestHeaders.Authorization = New AuthenticationHeaderValue(“Bearer”, apiKey) Dim url As String = $”{endpoint}/openai/vectorstores?api-version=2024-05-01-preview” Dim response As HttpResponseMessage = client.GetAsync(url).Result Console.WriteLine(response)End Using Read More
MGDC for SharePoint FAQ: How to restrict public access to storage accounts?
In this post, I’ll cover some details on how to configure the network access for the storage account used by the Microsoft Graph Data Connect (MGDC). If you’re not familiar with the MGDC for SharePoint scenarios, start at https://aka.ms/SharePointData.
Is public access required?
In the basic instructions for setting up MGDC in general (see guide) and in the specific instructions for MGDC for SharePoint step-by-step (see guide), you see the recommendation to set the network access setting for storage accounts to “Enable public access from all networks”. This is part of the configuration of the Azure storage account you need to use to sink the data coming from MGDC.
Using the “Enable public access from all networks” option is fine for many tenants, particular for Dev, Test and QA environments. To be clear, even with “public access from all networks”, you still need credentials and proper permissions to access the storage account.
However, several customers ask questions about further securing network access for MGDC storage accounts. That is possible, but you will need to a few additional configuration steps. This is something that might be required by your tenant, given the sensitive nature of this data.
Instructions for configuring restricted public access
While it is not possible to completely “disable public access” (third option under network access), there is guidance on how to “Enable public access from selected Microsoft networks and IP addresses” (second option in in network access). You can find it in the page for Troubleshoot Microsoft Graph Data Connect, in the topic for “Issues adding network IP address to allow list with Azure integration runtime”.
The document linked above explains that if the destination storage account needs further security, you can allow access only from a particular set of Azure service IP addresses.
In that article, note that some of the Azure regions cannot be used for hosting the storage account if you plan to use private access. Those Azure regions are marked with a “*” on the table mapping Office regions to Azure regions. For instance, that includes the “East US” Azure region for the “North America” office region, or the “West Europe” Azure region for the “Europe” office region.
Conclusion
I hope this clarifies that you can use the option to “Enable public access from selected virtual networks and IP Addresses” for your storage account networking when using the Microsoft Graph Data Connect. Be sure to read the detailed instructions and proceed with care. If you bump into any issues, do not hesitate to contact Microsoft Support.
Microsoft Tech Community – Latest Blogs –Read More
WORD in Dark Mode — some changes needed
I have become a massive fan of Dark Mode in recent months and never want to go back to glare-y white screens with black text. I had NO IDEA how much squinting I had been doing all those years of white backgrounds with black text.
I have a couple of problems with Dark Mode in Microsoft Word, however and could use some help… if there are ways to fix these problems.
Using:
Windows 11 Home
Desktop computer less than 1 year old with modest-performance RTX graphics
Intel 10-core i5 processor
32-inch Samsung Monitor with 3840×2160 resolution.
Problem #1… the squiggly red line that appears under misspelled words… it’s way too dark in color and intensity/luminance to be able to see easily in Dark Mode. Can I change the color assigned to the squiggly line in Dark Mode to a brighter color of red and perhaps make it 2-pixels wide instead of leaving it as 1-pixel wide? A side note… as I type this message in the MS Word User Forum, the squiggly red line HERE under a misspelled word is much easier to see than the squiggly red line in Word’s Dark Mode, which is much dimmer/darker and hard to see against the black background. I would be FINE with the squiggly line in Word, if it was as bright and visible as it is here in this forum (also displaying in Dark Mode with black background and white text). The squiggly line here in this forum is still 1-pixel wide, but easy to see.
Problem #2… during editing, for place-keeping, I will often change the font color once I have what I think is the final version of a paragraph. However, in Dark Mode (black background with white text), when I change the font color to, for example, red, the font on-screen remains white. How do I get the fonts in Word Dark Mode to change color correctly on-screen? These are all temporary font-color changes… once editing is complete, I change back to white text for screen display and black text/white background when anybody opens the document elsewhere. So this is a local viewing-on-the-monitor issue.
I have become a massive fan of Dark Mode in recent months and never want to go back to glare-y white screens with black text. I had NO IDEA how much squinting I had been doing all those years of white backgrounds with black text. I have a couple of problems with Dark Mode in Microsoft Word, however and could use some help… if there are ways to fix these problems. Using:Windows 11 HomeDesktop computer less than 1 year old with modest-performance RTX graphicsIntel 10-core i5 processor32-inch Samsung Monitor with 3840×2160 resolution. Problem #1… the squiggly red line that appears under misspelled words… it’s way too dark in color and intensity/luminance to be able to see easily in Dark Mode. Can I change the color assigned to the squiggly line in Dark Mode to a brighter color of red and perhaps make it 2-pixels wide instead of leaving it as 1-pixel wide? A side note… as I type this message in the MS Word User Forum, the squiggly red line HERE under a misspelled word is much easier to see than the squiggly red line in Word’s Dark Mode, which is much dimmer/darker and hard to see against the black background. I would be FINE with the squiggly line in Word, if it was as bright and visible as it is here in this forum (also displaying in Dark Mode with black background and white text). The squiggly line here in this forum is still 1-pixel wide, but easy to see. Problem #2… during editing, for place-keeping, I will often change the font color once I have what I think is the final version of a paragraph. However, in Dark Mode (black background with white text), when I change the font color to, for example, red, the font on-screen remains white. How do I get the fonts in Word Dark Mode to change color correctly on-screen? These are all temporary font-color changes… once editing is complete, I change back to white text for screen display and black text/white background when anybody opens the document elsewhere. So this is a local viewing-on-the-monitor issue. Read More
Apply one formula across multiple columns in one cell
I have a workbook with Titles, Tests, and Results across columns. I need cell T3 to return the Title if the result is Yes. Each Title should be on a new line. Right now I’m using 6 separate If functions, but in my real scenario, there are many more columns. Is there a way to simplify my formula so that one function can apply to many columns, but keep the results in the same cell?
I have a workbook with Titles, Tests, and Results across columns. I need cell T3 to return the Title if the result is Yes. Each Title should be on a new line. Right now I’m using 6 separate If functions, but in my real scenario, there are many more columns. Is there a way to simplify my formula so that one function can apply to many columns, but keep the results in the same cell? Read More
Microsoft free courses
Hi, Microsoft Team, please let me know, are Microsoft free courses available in Pakistan?? I am trying to click the link which is given for each free course, but unable to open that link. Please guide me and provide me with free courses. Regards
Hi, Microsoft Team, please let me know, are Microsoft free courses available in Pakistan?? I am trying to click the link which is given for each free course, but unable to open that link. Please guide me and provide me with free courses. Regards Read More
Exchange 2019/outlook 2016
Hello all. We have three exchange servers in different domains but they all fall under the same site(AD site and services) Our DC’s for the three domains also follow that topology. I think this impossible but I would like to ask the room. How do i get a outlook client in domain 1 to use the exchange in domain 1 and sof forth. When I open up outlook and show connection status I see connections from exchange servers in the different domains. like the SMTP is the correct domain but the in the server name column I have a few connections like https://mail.domain1.com https://mail.domain2.com and mail.domain3.com all established and connected. Without managing sites and services is there another way match the connection from client in outlook to the domain? I read about send and receive connectors but not sure if this would alleviate the problem. All ideas are welcome as i have been trying to figure this out
Hello all. We have three exchange servers in different domains but they all fall under the same site(AD site and services) Our DC’s for the three domains also follow that topology. I think this impossible but I would like to ask the room. How do i get a outlook client in domain 1 to use the exchange in domain 1 and sof forth. When I open up outlook and show connection status I see connections from exchange servers in the different domains. like the SMTP is the correct domain but the in the server name column I have a few connections like https://mail.domain1.com https://mail.domain2.com and mail.domain3.com all established and connected. Without managing sites and services is there another way match the connection from client in outlook to the domain? I read about send and receive connectors but not sure if this would alleviate the problem. All ideas are welcome as i have been trying to figure this out Read More
ADF Pipeline run parameters value pop-up
Hi
When i click debug in ADF pipeline, Pipeline run parameters pop-up. I put in parameter values but pipeline only sends the TableName i put in as value.
FYI – my pipeline has a control table with about 29 tables.
How do i fix this pipeline run parameter value issue?
Thanks,
Ken
Hi When i click debug in ADF pipeline, Pipeline run parameters pop-up. I put in parameter values but pipeline only sends the TableName i put in as value. FYI – my pipeline has a control table with about 29 tables. How do i fix this pipeline run parameter value issue? Thanks,Ken Read More
What is the best process in Outlook for follow-up with a client?
I have used Outlook for years and I know it has several reminder/tasks/to do features. I’m wondering what the best way would be for me.
I have clients where I get an email and I need to follow up, but a longer time period. This could be anywhere from 6 months to 2 years away, depending on the client.
The easiest for me is to right click the email, select follow-up, and then select my date. However, I would prefer to then delete the email but my understanding is that when I delete the email, I will be removing the reminder.
Any suggestions on the fastest and easiest way to set these reminders? I would like for them to be in my tasks/to do rather than just a pop up on the screen reminder.
Thank you.
I have used Outlook for years and I know it has several reminder/tasks/to do features. I’m wondering what the best way would be for me. I have clients where I get an email and I need to follow up, but a longer time period. This could be anywhere from 6 months to 2 years away, depending on the client. The easiest for me is to right click the email, select follow-up, and then select my date. However, I would prefer to then delete the email but my understanding is that when I delete the email, I will be removing the reminder. Any suggestions on the fastest and easiest way to set these reminders? I would like for them to be in my tasks/to do rather than just a pop up on the screen reminder. Thank you. Read More
App attach for Azure Virtual Desktop now generally available
App attach for Azure Virtual Desktop allows IT admins to dynamically attach applications from an application package to a user session in Azure Virtual Desktop.
In December 2023, we announced a public preview for some exciting new app attach features. App attach is now generally available and here is a summary of the new capabilities:
Applications can now be assigned to any host pool or session host. You can assign application packages to multiple host pools in your environment.
Applications can now be assigned per user, both within a desktop session and remote app sessions. This means that in any host pool in any session, users can be assigned different application combinations. This should reduce the number of host pools and images you require.
Application groups are no longer required to assign users to app attach apps, significantly simplifying assignment and reducing the number of application groups needed.
Application assignment, removal, and upgrades can be performed without needing a maintenance window and without interrupting a user’s workflow.
Microsoft Entra ID support for app attach has been introduced. Microsoft Entra hybrid join will work as it did before.
Dependency support has improved, including modification packages for remote apps.
A migration script is available to move existing MSIX app attach application packages to the new architecture.
We’re excited about these new features and recommend that any new app attach object be created using the new flow.
Now let’s look at these new capabilities:
Screenshot of the new Azure Portal UI for app attach.
Screenshot of the new Azure Portal UI for assigning users for an app attach package.
Learn more and share your thoughts
You can learn more about the new app attach features and Azure Virtual Desktop by visiting our Azure Virtual Desktop documentation pages. We’d love to hear your thoughts. Please leave a comment below!
Continue the conversation. Find best practices. Bookmark the Azure Virtual Desktop Tech Community, then follow us @MSWindowsITPro on X/Twitter. Looking for support? Visit Windows on Microsoft Q&A.
Microsoft Tech Community – Latest Blogs –Read More
Issue with Capturing Email Subject from URL Click Events
Hi Sentinel Community,
I am encountering an issue where the email subject line is not being captured correctly for certain records in my URL click event table. My goal is to get the URLs clicked by users along with the corresponding email subject lines. To achieve this, I applied a left outer join between the URL click event table and the email event table based on the network message ID.
However, after running the query, I notice that the subject column is empty for some records where users have clicked the URL, which was originally sent via email
the query which i used
UrlClickEvents
| search “email address removed for privacy reasons” // user name
| join kind= leftouter EmailEvents on $left.NetworkMessageId== $right.NetworkMessageId
//| where RecipientEmailAddress==”example.com”
| join kind= leftouter EmailPostDeliveryEvents on $left.NetworkMessageId== $right.NetworkMessageId
//|where isempty( Subject) and Workload =~”email”
| project TimeGenerated,Subject,SenderFromAddress=hash_sha256(SenderFromAddress),RecipientEmailAddress=hash_sha256(RecipientEmailAddress),Url=hash_md5(Url),Workload,NetworkMessageId=hash_md5(NetworkMessageId)
Hi Sentinel Community,I am encountering an issue where the email subject line is not being captured correctly for certain records in my URL click event table. My goal is to get the URLs clicked by users along with the corresponding email subject lines. To achieve this, I applied a left outer join between the URL click event table and the email event table based on the network message ID.However, after running the query, I notice that the subject column is empty for some records where users have clicked the URL, which was originally sent via email the query which i used UrlClickEvents| search “email address removed for privacy reasons” // user name| join kind= leftouter EmailEvents on $left.NetworkMessageId== $right.NetworkMessageId//| where RecipientEmailAddress==”example.com”| join kind= leftouter EmailPostDeliveryEvents on $left.NetworkMessageId== $right.NetworkMessageId//|where isempty( Subject) and Workload =~”email”| project TimeGenerated,Subject,SenderFromAddress=hash_sha256(SenderFromAddress),RecipientEmailAddress=hash_sha256(RecipientEmailAddress),Url=hash_md5(Url),Workload,NetworkMessageId=hash_md5(NetworkMessageId) Read More
NCE Renewal Window missed
Hi. I thought there’d already be topics on this, but….
We missed the 7 day window to modify (down) the number of seats for a client (NCE). By 2 days. Opened a ticket w/ Support. Support says nope, no exceptions. No, you cannot transfer the licenses to another client. No, you cannot get credit for the amount spent.
Any ideas on any outcome other than eating it?
Thanks in advance.
Hi. I thought there’d already be topics on this, but…. We missed the 7 day window to modify (down) the number of seats for a client (NCE). By 2 days. Opened a ticket w/ Support. Support says nope, no exceptions. No, you cannot transfer the licenses to another client. No, you cannot get credit for the amount spent.Any ideas on any outcome other than eating it?Thanks in advance. Read More
SharePoint Add-in retirement :Possible path to migrate a hosted add-in
In reference to this article here – https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/retirement-announcement-for-add-ins
I would like to know the possible options to replace existing SharePoint add-in’s using SharePoint Framework and the path to migration.
A little background:
We have a SharePoint Hosted Add-in developed using knockout.js which is a form application that does CRUD operations and also has a XAML workflow for approvals. It is packaged as an app via the app catalog.
Is it possible to re-use the existing add-in and deploy the solution using SharePoint Framework or is this application need to be re-built using the SPFX webparts? Any help or guidance is greatly appreciated. Thank you in advance.
In reference to this article here – https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/retirement-announcement-for-add-insI would like to know the possible options to replace existing SharePoint add-in’s using SharePoint Framework and the path to migration. A little background:We have a SharePoint Hosted Add-in developed using knockout.js which is a form application that does CRUD operations and also has a XAML workflow for approvals. It is packaged as an app via the app catalog.Is it possible to re-use the existing add-in and deploy the solution using SharePoint Framework or is this application need to be re-built using the SPFX webparts? Any help or guidance is greatly appreciated. Thank you in advance. Read More
Cant access link shared in Onedrive
Hello
Please i need your help on this issue.
One of my user has left the organization we are trying to retrieve the link he shared to in OneDrive but we cannot.
Most of the problems are for the files shared in 1-1 chats and user created Teams chat groups. We are not able to access it now. For some, we get the URL and when we manually update the UPN in the suffix, we are able to see the files in the Explorer and the others don’t even see the URL.
Second is the leavers for whom users had shared the file previously and it not accessible right now.
HelloPlease i need your help on this issue. One of my user has left the organization we are trying to retrieve the link he shared to in OneDrive but we cannot. Most of the problems are for the files shared in 1-1 chats and user created Teams chat groups. We are not able to access it now. For some, we get the URL and when we manually update the UPN in the suffix, we are able to see the files in the Explorer and the others don’t even see the URL.Second is the leavers for whom users had shared the file previously and it not accessible right now. Read More
Interactive ink tutorial in OneNote
Hi Microsoft 365 Insiders,
Discover the capabilities of OneNote with our interactive ink tutorial! Our fun tutorial uses a show-and-tell approach to thoroughly introduce you to the possibilities of ink notetaking in OneNote for Windows. With helpful videos showcasing various ink features, like the innovative ink-to-text pen, and hands-on activities, you’ll be an ink expert in no time.
Check out the latest blog by Sofia Thomas, Product Manager on the Office AI team, to get started: Interactive ink tutorial in OneNote
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi Microsoft 365 Insiders,
Discover the capabilities of OneNote with our interactive ink tutorial! Our fun tutorial uses a show-and-tell approach to thoroughly introduce you to the possibilities of ink notetaking in OneNote for Windows. With helpful videos showcasing various ink features, like the innovative ink-to-text pen, and hands-on activities, you’ll be an ink expert in no time.
Check out the latest blog by Sofia Thomas, Product Manager on the Office AI team, to get started: Interactive ink tutorial in OneNote
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
CSP Partners – Statements (not to confused with a Tax Invoice)
Microsoft provides Tax invoices every month to Partners. But why do they not provide Statements, even a formal channel by which we as Partners can make a request for a certain period/periods?
Our Auditors needed Statements for 2 financial periods for our complete Azure bill, all we had were the Tax Invoices that Microsoft send us Partners. Tax Invoices and Statements as we know serve two very different purposes.
Anyone knows why Microsoft does not provide Statements, and if not, is that a a formal channel on the portal to make these requests as and when we need Statements for a given period?
Microsoft provides Tax invoices every month to Partners. But why do they not provide Statements, even a formal channel by which we as Partners can make a request for a certain period/periods? Our Auditors needed Statements for 2 financial periods for our complete Azure bill, all we had were the Tax Invoices that Microsoft send us Partners. Tax Invoices and Statements as we know serve two very different purposes. Anyone knows why Microsoft does not provide Statements, and if not, is that a a formal channel on the portal to make these requests as and when we need Statements for a given period? Read More
Live and Draft Campaigns Not appearing in Amplify Camaigns
I am working with a client, training on amplify. As we create test campaigns, in the past week, none of the new campaigns are appearing in the Campaigns list for users. Only campaigns they create appear. Users can use the email link informing them they were invited to a campaign to reach the campaign, but it still won’t appear in their list.
I am working with a client, training on amplify. As we create test campaigns, in the past week, none of the new campaigns are appearing in the Campaigns list for users. Only campaigns they create appear. Users can use the email link informing them they were invited to a campaign to reach the campaign, but it still won’t appear in their list. Read More
Excel Clipboard Format
If this is the wrong place for this question, please point me to the correct place.
If you copy data from Excel, and then paste it into another application, you will generally get numbers formatted in the same manner they appeared in Excel. For for example, if you have a cell with the value “1.025368” that is formatted to 3 decimal places (1.025), and you copy and paste this to another application, then “1.025” is what will be pasted.
If you are writing a program that wants to read the full number from the system Clipboard, there are multiple formats that the clipboard can hold. The normal format is “Text” — where each cell is separated by a tab, and each row by a newline character. But when you copy from Excel, it also inserts an “XML Spreadsheet” format of data that looks like this when you retrieve it:
<ss:Workbook xmlns=”urn:schemas-microsoft-com:office:spreadsheet” xmlns:o=”urn:schemas-microsoft-com:office:office” xmlns:x=”urn:schemas-microsoft-com:office:excel” xmlns:ss=”urn:schemas-microsoft-com:office:spreadsheet” xmlns:html=”http://www.w3.org/TR/REC-html40″>
<ss:Styles>
<ss:Style ss:ID=”Default” ss:Name=”Normal”>
<ss:Alignment ss:Vertical=”Bottom” />
<ss:Borders />
<ss:Font ss:FontName=”Arial” x:Family=”Swiss” ss:Color=”#000000″ />
<ss:Interior />
<ss:NumberFormat />
<ss:Protection />
</ss:Style>
<ss:Style ss:ID=”s63″>
<ss:NumberFormat ss:Format=”0.0000″ />
</ss:Style>
<ss:Style ss:ID=”s64″>
<ss:NumberFormat ss:Format=”0.000″ />
</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name=”Sheet1″>
<ss:Table ss:ExpandedColumnCount=”4″ ss:ExpandedRowCount=”5″>
<ss:Row>
<ss:Cell ss:Index=”2″ ss:StyleID=”s64″>
<ss:Data ss:Type=”Number”>1.0253680000000001</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row ss:Index=”4″>
<ss:Cell ss:Index=”3″ ss:StyleID=”s63″>
<ss:Data ss:Type=”Number”>15.236548900000001</ss:Data>
</ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook>
So far so good…this allows us to pull out the full number. However, the <ss:Row> and <ss:Cell> values are only present for non-blank rows and non-blank cells. You can see that they have an “Index=” attribute that is supposed to tell you what row number and column number these values belong in.
The problem is that this doesn’t seem to be true for the very first row. In the above code, I had actually copied a blank row, as shown in this next picture:
There doesn’t seem to be a way to know that the first cell value is actually on the second row instead of the first. This seems like a bug with Excel, right? How does one get that addressed?
If this is the wrong place for this question, please point me to the correct place. If you copy data from Excel, and then paste it into another application, you will generally get numbers formatted in the same manner they appeared in Excel. For for example, if you have a cell with the value “1.025368” that is formatted to 3 decimal places (1.025), and you copy and paste this to another application, then “1.025” is what will be pasted. If you are writing a program that wants to read the full number from the system Clipboard, there are multiple formats that the clipboard can hold. The normal format is “Text” — where each cell is separated by a tab, and each row by a newline character. But when you copy from Excel, it also inserts an “XML Spreadsheet” format of data that looks like this when you retrieve it: <ss:Workbook xmlns=”urn:schemas-microsoft-com:office:spreadsheet” xmlns:o=”urn:schemas-microsoft-com:office:office” xmlns:x=”urn:schemas-microsoft-com:office:excel” xmlns:ss=”urn:schemas-microsoft-com:office:spreadsheet” xmlns:html=”http://www.w3.org/TR/REC-html40″>
<ss:Styles>
<ss:Style ss:ID=”Default” ss:Name=”Normal”>
<ss:Alignment ss:Vertical=”Bottom” />
<ss:Borders />
<ss:Font ss:FontName=”Arial” x:Family=”Swiss” ss:Color=”#000000″ />
<ss:Interior />
<ss:NumberFormat />
<ss:Protection />
</ss:Style>
<ss:Style ss:ID=”s63″>
<ss:NumberFormat ss:Format=”0.0000″ />
</ss:Style>
<ss:Style ss:ID=”s64″>
<ss:NumberFormat ss:Format=”0.000″ />
</ss:Style>
</ss:Styles>
<ss:Worksheet ss:Name=”Sheet1″>
<ss:Table ss:ExpandedColumnCount=”4″ ss:ExpandedRowCount=”5″>
<ss:Row>
<ss:Cell ss:Index=”2″ ss:StyleID=”s64″>
<ss:Data ss:Type=”Number”>1.0253680000000001</ss:Data>
</ss:Cell>
</ss:Row>
<ss:Row ss:Index=”4″>
<ss:Cell ss:Index=”3″ ss:StyleID=”s63″>
<ss:Data ss:Type=”Number”>15.236548900000001</ss:Data>
</ss:Cell>
</ss:Row>
</ss:Table>
</ss:Worksheet>
</ss:Workbook> So far so good…this allows us to pull out the full number. However, the <ss:Row> and <ss:Cell> values are only present for non-blank rows and non-blank cells. You can see that they have an “Index=” attribute that is supposed to tell you what row number and column number these values belong in. The problem is that this doesn’t seem to be true for the very first row. In the above code, I had actually copied a blank row, as shown in this next picture: There doesn’t seem to be a way to know that the first cell value is actually on the second row instead of the first. This seems like a bug with Excel, right? How does one get that addressed? Read More
Unique Lists
Have a spreadsheet with a list of employees. Imagine, just simple basic info. Now, on another tab, have certifications and training (if completed) tied to the employee. I was thinking of a Unique list, but that won’t work in a table. Turn the employee list into a query, so it updates on the other sheets?
Have a spreadsheet with a list of employees. Imagine, just simple basic info. Now, on another tab, have certifications and training (if completed) tied to the employee. I was thinking of a Unique list, but that won’t work in a table. Turn the employee list into a query, so it updates on the other sheets? Read More
Form URL Link
I have a Form that I created that is for drivers to check in to our warehouse for picking up items.
The issue is we now have drivers that frequently pick up from our warehouse and they are bookmarking the Form and checking in despite not be on the premises. Is there a way to change from time to time the url? I posted just the QRcode at warehouse entrance but Drivers saved the link. Or what can I do to make sure that
I have a Form that I created that is for drivers to check in to our warehouse for picking up items.The issue is we now have drivers that frequently pick up from our warehouse and they are bookmarking the Form and checking in despite not be on the premises. Is there a way to change from time to time the url? I posted just the QRcode at warehouse entrance but Drivers saved the link. Or what can I do to make sure that Read More
I’d like to have two (or more) images side-by-side without creating a new section.
I’m using the collapse option for this section so creating a new two column section isn’t really an option (unless you can put a section within a section?).
How else might I be able to have two (or more) images presented side-by-side?
I’m investigating doing this with the embed element but haven’t figured out the proper code (or viability) yet.
The images are the same size and in the page’s asset folder.
Example: image1.jpg image2.jpg
I’m using the collapse option for this section so creating a new two column section isn’t really an option (unless you can put a section within a section?). How else might I be able to have two (or more) images presented side-by-side? I’m investigating doing this with the embed element but haven’t figured out the proper code (or viability) yet. The images are the same size and in the page’s asset folder. Example: image1.jpg image2.jpg Read More
