Does anybody have any suggestions here? I have a really hacky workaround in mind but would love to hear from others if they have anything slicker.
Current plan:
- Webhook1: after a record is added to Table A, if the effective date is <= today(), create a record in Table B (final destination).
- Webhook2: after a record is added to Table A, if the effective date is > today(), create a record in Table C (interim table).
- Schedule QuNect to transfer data from Table C to Table D daily at 5am, triggering subsequent Webhooks.
- Webhook3: after a record is added to Table D (by QuNect), if the date is = today, create a record in Table B
Step 3 just seems really awkward, stepping out of the QuickBase software just to schedule an action.
