June Office Hours

AppSheet Announcements
1

It’s the end of June already!

@Derek, @Phuong and I are getting started with AppSheet Office Hours at 9am PT, and besides doing live Q&A for your questions, the agenda will include:

  • New Feature: Workflow Step Rearrangements
  • New Feature: Automatic App Documentation
  • Internal AppSheet App Preview: ‘Collateral Portal’
  • Using GPS & Barcode Scanning for field service check-ins
  • Using Security Filters for data control & improved performance
  • Using Webhooks to track app activity
  • Use virtual column to simulate double dereference

You can register here (if you can’t make it, register and the recording will be emailed). Please post any questions you have for office hours here!

3 Likes
2

Can see and hear you guys

1 Like
3

Printing the selected Questions

I will explain to you the the problem detail with pictures. From your page ( Documentation > All Collections > BEHAVIOR > Advanced Topice > Printing Your Data ) [1] 1 - If i choose the SIDE-BY-SIDE style ( UX/OPTIONS/DETAIL VIEW ). Printing the selected text is correct in ( Phone vertical Mode ). ( i.e Title aligned to the lift side & text aligned to right side ) [2-1] After i press ( Ctrl + P ) it will become like this. [3-1] 2 - If i choose the SIDE-BY-SIDE style ( UX/…

1 Like
4

Is it possible to have the Action buttons “Inspect” aligned to the left vs. all on the right?

1 Like
5

Will there be a GPS feature that allows you to track shipments in real time or with a very small delay?

1 Like
6

Can we find this app to play around with it?

1 Like
7

https://www.appsheet.com/portfolio/626900

2 Likes
8

Auto app documentation of my app created 132 pages. It would be great if this could be consolidated.

1 Like
9

Are user settings limited to just the 10 columns?

1 Like
10

Security filter doesn’t seem to be available for my Publisher PRO plan.

1 Like
11

Sight and sound confirmed

1 Like
12

Sorry I couldn’t post before now: This question pertains to the location tracker app: Could an action be created to auto assign an inspection to an inspector based on nearest location?

1 Like
13

Hello, not related yet to what’s going on - if someone can tell me what to research I would be grateful.

I want to add to create/add a line item from a list of products and add it to an existing quote (or new quote). I have 10,000+ items, easily searchable by groups, it makes sense to 1. find the item & 2. add it to something.

It doesn’t not make sense to 1. make a quote or invoice & then 2. choose the item, because I can’t have a dropdown with 10,000 items.

More specifically - I make line items from a list of 10,000 possible products, the line item is the product with images and the condition and value estimate noted. Imagine a list of existing cars and my line items are used cars, the app make estimates for how much my employees will pay a person to buy the given used car model for our shop.

1 Like
14

On Total Clicks - Is it possible to do something like this in Publisher Pro when there are no particular users? Are Webhooks available in Publisher Pro?

1 Like
15

Webhooks: When sending data from one app to another, how is security handled?

1 Like
16

Collateral App: Do we have access to the Collateral Application? Helps with our local marketing efforts as well

1 Like
17

Hi @cameraville ,

Here is documentation on dependent dropdown that you might find helpful for your use case - https://help.appsheet.com/articles/961554-dependent-dropdown.

Let me know if you have any questions!

1 Like
18

For those interested in the double dereference, I have a sample app that highlights the process. Feel free to check out at the link below! https://www.appsheet.com/samples/Demo-to-simulate-double-dereference?appGuidString=ccb0eacb-66d6-44c7-b7c9-11ce2636d4eb

2 Likes
19

How much will app sheets cost to publish?

Q: Is there any way we can put the app without publishing it, int our websites google drive?

Q: can we upload documents, more than 1 sheet per column?

Q: How do you link sheets together and put it on app sheets?

20

Hi @Kate_Hornyak!

Thank you for attending our webinar session today.

I’m following up with your questions below:

1. Q: How much will app sheets cost to publish?

You can take as much time as you need to start building and testing your secure app for free with up to 10 users testing your app & providing feedback. When you’re ready to publish it to the rest of the team, we have subscription plans that would allow you to bring on more users and have access to our more advanced features, including some of those that were covered in today’s session. You can find more info about our offerings here: https://solutions.appsheet.com/pricing

2. Is there any way we can put the app without publishing it, int our websites google drive?

You do have the ability to whitelist a given list of users when deploying your app. This way, you’re able to limit the number of users who have access to the app. Here’s a helpful page talking about this feature: https://help.appsheet.com/articles/2382138-users-the-essentials

3. Can we upload documents, more than 1 sheet per column?

We do have this capability. I suggest having multiple sheets within the same doc to help organize your data. When creating your table within the editor, you will able to select the specific sheet you’d like to upload to the app. Here is an example of an app using this functionality:

https://www.appsheet.com/samples/Inspection-app-for-equipment-across-multiple-facilities-with-a-map-view-charts-and-security-filters?appGuidString=cb34324e-2f8f-4291-8f7e-102c701f51c5

If you go to the “Facility” table → View Source, you can see that the doc contains several sheets.

4: How do you link sheets together and put it on app sheets?

You will still have access to all of the separate Google sheets in your drive. For the example above, the “Facility” and “Equipment” tables were generated from two separate Google sheets: Facility and Equipment respectively. You can find this info by going to “View Source” for both tables. Once the sheets are uploaded as tables, one way you can map data across them is to use our Formulas functionality; which you can learn more about here: https://help.appsheet.com/articles/961507-app-formulas-and-initial-values

Let me know if you have any other questions!

1 Like