10/15 Office Hours

Join us Tuesday morning at 9AM PT for the next Office Hours. In addition to your live questions, we’ll try to address a few topics below. (Register even if you can’t attend but would like a recording emailed to you)

New Features to Discuss:

  • True/False Toggle Actions
  • ‘Ordered-Flow’ Actions
  • New Options for Multi-Choice Buttons

A few more features to highlight:

  • Ideas for Translating Languages
  • Deck & Inline Deck Views
  • Multiple Map Layers

Also, we’ll demo some new methods for showing quick tutorials of the platform - curious to hear feedback. See you then!

UPDATE: Below is the recording from this weeks session. Let us know if you have any additional questions!

2 Likes

Will there be a tutorial for working with mysql?

2 Likes

Hi!
I’m trying to build an app to calculate the Nurse Activity Score.
This score is the sum of several variables (colums).
Most of the colums are enumlist or true/false type columns.
Depending on the answer given for each variable, a value (decimal number) must be assigned to that variable,
The idea is to get a total score that would be the sum of all the values assigned to the variables.

For example, the variable [monitoring] can be given 3 possible answers -----> number:
normal ----> number 4.5
more than normal .------> 12.1
much more than normal ------> 19.6

I’ve been trying with ifs function and ifs(in function but couldn’t get the syntaxis righ.
Can anyone help with a detailed way to write this formula?

Thanks!
Cecilia

Gantt view under calendar would be great. Month view does not work for projects.

Hi. I’m in the UK and over recent weeks my team have noticed a marked slowdown in the syncing of the myriad of apps we use in our business. Is it likely that our distance from the Appsheet server is contributing to this? If so is there any way to prevent our apps from slowing as the quantity of data in the spreadsheets increases over time?

1 Like

We are vintage clothes seller in UK. We are using the OCR feature for scanning inside clothing labels. for sizes, washing instructions etc. to list items quicker.

It works quite well , until the size isn’t there i.e Size 10 Size 12 is fine but then some labels have just 10 , 12.

1 Like

Thanks for your question @1111 ! Here’s a reference doc to provide additional information about working with mysql. We’ll do our best to review this during the Q&A portion of our session.

I use no formulas in sheets, only in apps. I’ll look into security features and partitioning. How many rows would start to ring alarm bells? Thanks

We moved our data from Smartsheet to an Azure sql db but noone can figure out how to get the images to display. Are there some good instructions for storing images in the db and displaying in app?

Thank you for joining the webinar! Here is a support article for SQL database integration: https://help.appsheet.com/en/articles/962066-using-data-from-mysql. Please let us know if you have any questions.

I currently have 12 apps - all identical except for the slices that were used to filter the data based on location. I’d really like to cut this down to 1 app and use the security filters but need to make sure the tables display the correct data. Would this just be on the location = X ?

or is there a way to create a view to have the user select the location and then just display the data based on that location?

Will we be able to have the view right to left anytime soon? In hebrew we write right to left

What a great way to use the OCR feature @Paul_Lou_M_palocell! It sounds like you may need to retrain how the system is reading the size field. We’ll do our best to answer this question during the Q&A but here’s an additional resource on OCR to help.

Hi @timsimpson! Thanks for your question! Here’s an additional resource to assist with sync speed.

Peter recommended connecting to Active Directory. Sounds great. Is it feasible to connect to Azure Active Directory? How?

1 Like

Here’s the expressions article containing information about CONTEXT. Please let us know if you have additional questions.

Hi @Rich_Barber thanks for your question! Here’s a quick reference doc about Azure Active Directories.

Hi @Rich_Barber! Thank you for your feedback. We currently do not have a gantt view available, but there is a chart view that may be able to satisfy your needs for the time being. Here’s a help doc on the different views available for reference.

Hi Tammi - this might be a great use-case for ‘User Settings’. You can include the user-selected settings in your security filters, slices, show_if conditions, etc.

1 Like

This is awesome!