Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Link to dates in form
- This topic has 4 replies, 3 voices, and was last updated 3 years, 4 months ago by matt coxon.
-
AuthorPosts
-
July 27, 2021 at 11:25 AM #44867
matt coxonParticipantHi , is it possible to create a simple project plan with date dependencies . So if I change a date in a task the link tasks date changes automatically.
All in one form with no linked forms
Thanks
MattJuly 27, 2021 at 10:21 PM #44870
Sam MoffattParticipantI don’t think there is an easy way to do this, or even a hard way for that matter.
The feature you’d need is self linking forms and whilst it sort of works, it only does so for M:M links when for this you’re building a tree like structure that would be 1:M. I got something sort of working with two link to form fields but it was janky and didn’t quite work the way I’d like and would still put the parent record in the child section. That would mean a second form to store the links and likely a bunch of scripting to replicate the TF record picker. Not impossible and with a lot of work, you could build the linking infrastructure you’d need to make it work and then once you’ve got that a moderately complex script field could push the update.
July 27, 2021 at 10:29 PM #44871
matt coxonParticipantHi Sam, thanks for replying. I’ll put it on the way too difficult shelf for me and move on
Thanks
MattJuly 28, 2021 at 1:31 AM #44873
BrendanKeymasterI wonder if a Table field would be ideal for this sort of thing?
Do you mean that if you change a date on the Parent record, all the linked records would have their dates updated? So if the parent field had a Project Start Date and the Table field had a Task Start Date, if you change the Project Start Date to something later, the Task Start Date for each task would also change?
If so, then a Script field would certainly be able to do this. Just loop through all the Table field records and update the Task Start Date depending on the Project Start Date.
I don’t know if it would be all that difficult. And doesn’t use a Linked form, although a Table field is similar to a Link to Form field in the way it displays. It just doesn’t have a separate form for it. The sub-fields are all configured on the Table field itself.
But maybe I’m misunderstanding the requirement.
Thanks,
Brendan
August 2, 2021 at 2:40 PM #44895
matt coxonParticipantThanks Brendan, I’ll have a look into it further based on your reply
Thanks
Matt -
AuthorPosts
You must be logged in to reply to this topic.