how do I create an append query?
I need to create an append query. I have a "leads" table that outside agents populate with a potential sales lead. Once my agent accepts the lead he changes the status of that lead. I need a quer...
Forum Discussion
In QuickBase, there are two native methods to do this, ie without using non native script.
If you look for HELP on keyword API, you will find a decent set of APIs.
These can be triggered by using a formula URL field (button) for the user to click. I have posted an app in he Exchange called URL Formulas for Dummies, which gives some example, and in particular how you string multiple API calls together in a sequence.
For example, in your case you would want to API_AddRecord, and then call and API_DeleteRecord, and then you will need to display a record or a report or a Dashboard or else the screen will spew some XML success message to your user, which is not user friendly.
Another option is using Webhooks, which were just recently released.
My suggestion in your case is to use the URL formula buttons. I will post an example for you when I get a chance, but meanwhile read the tips in that app I posted to the Exchange.
If you look for HELP on keyword API, you will find a decent set of APIs.
These can be triggered by using a formula URL field (button) for the user to click. I have posted an app in he Exchange called URL Formulas for Dummies, which gives some example, and in particular how you string multiple API calls together in a sequence.
For example, in your case you would want to API_AddRecord, and then call and API_DeleteRecord, and then you will need to display a record or a report or a Dashboard or else the screen will spew some XML success message to your user, which is not user friendly.
Another option is using Webhooks, which were just recently released.
My suggestion in your case is to use the URL formula buttons. I will post an example for you when I get a chance, but meanwhile read the tips in that app I posted to the Exchange.
Could you help me find your app URL Formulas for Dummies? I seem to be even more of a dummy than expected : )
Thank you.
Thank you.
