Solved: How to use AppSheet with AutoCAD (or other CAD sof...

Wojciech_Sz · 07-02-2021 03:43 AM

Hello!
I’ve been using AppSheet in an engineering company that needs to prepare documentation (Sheets) with localizations on DWG drawings. It is achievable in AppSheet and convenient to frontline workers.

Check out post on my website:

Fabian_Weller

That’s awesome @Wojciech_Szczepanik
Imagine if we could export the .scr file directly from the AppSheet App.
Actually we can export .xml files. You could then change the file extension to .scr

I did the same with .kml files

Adding @Phil

Wojciech_Sz

@Fabian Would be great to export .scr files from App.
AutoCAD gives a lot more features. We can think maybe about some API connection?

What must be said:

AppSheet saves coordinates in format X.XXX, Y.YYY when X, Y <100, and Y-axis is pointing down. Changing the axis in AutoCad is a bad idea. I tried to separate Y to a different column and make operation [100-Y.YYY) but this is generating a little too much mess in the app. That’s why I used the new sheet. Maybe you have other ideas?

Fabian_Weller

I think you don’t need to have the image as a square 100 by 100 units. If you know the width and the high you can calculate the XY values as I did here.
You could do all the calculation directly in AppSheet and then export it as a XML file. You then just have to change the file extension to SCR.
With this, you would only work in the AppSheet App, without the need to copy things in Google Spreadsheet.

Wojciech_Sz

Hi!

I figured out a new way to connect AppSheet and AutoCAD.

Even simpler! Without creating a new file.

Everything you need is to copy cells from Google Sheets and paste into AutoCAD console.

We need the output in this format:

(command "_mleader" "XX.XXXXXX,YY.YYYYYY" "@5,5" "your_text")

How to achieve that?

Look at the sheets I created - New method1 and New method2