If I want to allow a user to be able to modify an entry but that entry is located in more than one DS. How would I go about that? Im using the Autobind feature. I thought about using a workflow but the entry has changed and that means the workflow doesnt work because the condition doesnt match.
Im not keen on multiple autobind fields because that opens up the user to entering in different values in each field accidentally.
Hi! Can you give me an example for this so that I can understand your use-case better?
So I have a data set with all the ingredient information, the user selects an ingredient and the ingredient name becomes part of another dataset making up the entry into the formulation.
If the user wants to change the name of the ingredient, spelling error etc, I want that to reflect in both DS but only by making the one change
Ah okay, in that case, you can add a table in your database called Ingredient with an attribute called Name
In Formulation, you can have a list of Ingredients
Now, when you change the Ingredient’s Name, the same will be reflected in Formulation as well, since it’s a link
Let me know if this makes sense 
Im not sure I follow. I havent done much with lists. are they like a DS like users can add to them? The ingredient list DS has about 15 fields regarding the ingredient. This is all scientific stuff not like flour etc.
Do you want to get on a quick 15-minute call sometime tomorrow? Happy to explain this to you if you need
Cheers mate, thinking a bit further about it Im looking at it from a one user point of view but its gonna have a heap of users. If one user makes a change they could affect the formulations of multiple users and screw them up. So I might not allow modifications.
Understood, yeah. Better to evaluate then if you need something like this in the first place. Either way, always happy to help
This topic was automatically closed after 70 days. New replies are no longer allowed.