Updating Autorecorded entries

[ABDEL-23]

Hi,
I'm auto-recording to bkper from a G-sheet that gets entries from another app.

The bkper API doesn't detect line modifications: only record added new lines, how to make it record modifications?

Also, let's consider this case to make it simple:
I record from an app (independant) to Gsheet.
I auto-record from the Gsheet to bkper ( the new lines are detected every time and get green)
Now, I deleted an entry into the app, consequently the entry is deleted from Gsheet, but not from Bkper. Also the sheet Deleted line stays green ( as already recorded to bkper).
If I add a new entry app, then gsheet, it comes to the free line but as it is still green nothing is recorded to Bkper.

So the requests :
How to enable modification of entries in Bkper?
More specifically how to make the auto-record feature sensitive to Data modification, or at least when a line gets blank reiterirate its position to the previous line.

Thanks!

[maelcaldas]

Hi,

Thanks for the feedback and suggestion.

You are right, the line pointer goes rolling for next lines. To reset to the last line after erase some lines you can disable and reenable the auto-record feature, and the pointer will be set to the last blank line.

About enabling modifications and improve data sync back and forth, looks a nice improvement. We will discuss with the team and let you know about our progress here in this issue.

Many Thanks
Mael

[ABDEL-23]

Thanks for the quick answer, really appreciate it !

Your suggestion is right, the only problem I want it automised as I'm syncquing bkper with another app. Is there a way to automise it?
( Like set the pointer to the previous line if the current pointed line is blank?)
I reallly really need this feature and don't know how to proceed. If it's not possible through bkper, is there a solution through gsheet directly? ( I mean by that, for instance a macro that would activate and deactivate the bkper addon auto sync...)

Thanks again!

[maelcaldas]

You'r welcome! :-)

Maybe that could be achieved using the BkperApp apps script library (the one used to build the sheets add-on), or our Zapier connector

We are currently working heavy on improving the API and SDK', so would you mind sharing a little bit more of your case, so we can have more idea of your needs and walk in the right direction to attend?

Thanks
Mael

[ABDEL-23]

Thanks, will check that out.

Yes sure, I want to connect a data entry app made in appsheet ( https://www.appsheet.com/) to bkper.

The app generates a gsheet file with all the customised information, I treat it in another gsheet and then autorecord to bkper. The app enable modification, but if this happens, bkper bugs because of the pointer problem