Forum Discussion
RichardPfister
8 years agoQrew Cadet
Thanks for your response Matthew.
I didn't think about the text version of the name. If I could sequence the webhooks to ensure the table is created before trying to add records to it then I could use that.
The Why:
Every month certain tax filings are due. We have to track the various stages of their completion with notes from the accountant processing them and prior months' details have to be preserved. Some months include quarterly items or annual items so each month is not identical. I can create a master table using generic references such as "3rd of the month" or "every 4th Tuesday", but the individual monthly tables will have the precise date and time ("July 15th, 8am") calculated from that table. The master table can change from time to time with items added or removed, so it would be pointless to create all the monthly tables in advance, hence the user-input trigger.
I'm definitely open to the idea that I'm doing it the wrong/hard way (see profile pic) but in this case I don't know of a better approach regardless of technology being used. Do you see another solution? Thanks!
I didn't think about the text version of the name. If I could sequence the webhooks to ensure the table is created before trying to add records to it then I could use that.
The Why:
Every month certain tax filings are due. We have to track the various stages of their completion with notes from the accountant processing them and prior months' details have to be preserved. Some months include quarterly items or annual items so each month is not identical. I can create a master table using generic references such as "3rd of the month" or "every 4th Tuesday", but the individual monthly tables will have the precise date and time ("July 15th, 8am") calculated from that table. The master table can change from time to time with items added or removed, so it would be pointless to create all the monthly tables in advance, hence the user-input trigger.
I'm definitely open to the idea that I'm doing it the wrong/hard way (see profile pic) but in this case I don't know of a better approach regardless of technology being used. Do you see another solution? Thanks!