How to use Dynamic Data Mapping feature with OptiSigns

With Pro Plus and Enterprise plan, you can dynamically map data from Google Sheets or Microsoft 365 Excel to your each of your screens. 

This is useful for case that you have data changing frequently and/or differ from locations to locations. Here are some common use cases:

  • Restaurant Menu, Promotion where prices, availability changes and/or differ from locations to locations
  • Retail, Hospitality promotions, messages
  • Employees birthday
  • Employees recognition, score boards

You can use our Designer to turn the price into a Dynamic Data Mapping, then map it to Google Sheets or Microsoft Excel Sheets.

You can also use Zapier to integrate with your POS, Inventory management, HRIS or other systems to Google Sheets to automate your pricing, availability changes, or employee engagement data.

  • How to use the data mapping feature with Google Sheets, you can click here.
  • How to use the data mapping feature with Microsoft 365 Excel, you can click here.

Some frequently asked questions about Dynamic Data Mapping:

1) Can I map data from Application XYZ?

Yes, you can use Zapier to automate data from your application to update the Google Sheets or Microsoft Excel Sheets generated by OptiSigns. Zapier have thousands of integrations to many apps POS, HRIS, Employee engagement, sales, customer support, project management, etc.

If your application is not supported by Zapier, you can build your own integration to Google Sheets AP or Microsoft Excel Sheets API.

2) How quickly the screens will be updated from the time data is changed in Google Sheets or Microsoft Excel Sheets?

Google Sheets and Microsoft Excel do not have published SLA on how fast it webhooks will be called. Usually, when the changes is small (affect a few rows) it's less than 1 min, but sometimes, it can take longer. Especially if you are making a lot of changes to the Google Sheets and Microsoft Excel Sheets, it can take a while for Google Sheets and Microsoft Excel to send updates.

3) Does it require my device be connected all the time? What if the device lost internet?

Internet connection is required to push the changes through, but if the device does not have internet, it will just keep playing old data.

4) What's the easiest way to get image URL?

You can upload your image to Files/Assets just like any other files and copy the URL to use in your mapping.

 

If you have any additional questions, concerns or any feedback about OptiSigns, feel free to reach out to our support team at support@optisigns.com