I looking for a better way to automate this. Right now, I am just coping each field manually one by one, and manual paste for each field. Looking for idea how to use KM, to copy some fields over to Google Sheets. I am flexible as to how much interaction I can supply, just so I can cut down on the number or steps involved. Using FM 16 Advanced. Any tips to get me started would be great. I did browse some older posts that involve KM and AS, just not sure if those steps are still valid or best way.
Step 1 - Assign KM Variables in KM Prefs
Step 2 - Filemaker AS to copy necessary fields to AS Variables
Step 3 - KM - Macro to copy AS variables to KM Variables
Step 4 - KM - Marco to copy KM Variables over to Google Sheet cells.
Does this sound like it will work, or is this not the correct approach?
You could do it like that, but IMO Steps 3 & 4 are not necessary.
So I don't see much added value by using KM. (and please note I'm a huge KM fan. If there was a better KM solution I would point it out).
I was also thinking that the right way of doing it, is just like FatPanda, however it is not even close. I have tried to Assign KM Variables in KM Prefs and after that to Macro to copy AS variables to KM Variables, but this did not work, not at all. It gives a freaking error, and I do not know how to fix it after that! I actually think that exporting to CSV or Excel, especially to Excel has to be the best option. I have read something about a similar project on https://blog.coupler.io/gravity-forms-to-google-sheets/, however I do not really think it would work on CSV.