Update record to another table if not exist

[Gismo1233]

Hi all,

Please could you assist?
When I create a new part number in orders layout, the part must be created in the parts table only if the part number does not exist
My script goes into an endless loop and does not add the part

[comment]

Didn't you post this on Claris Community?

Anyway, I either don't understand your description or your script, because I don't see the connection between the two. And of course your script will go into infinite loop:  You have no Exit Loop If  step and you have turned off the Exit after last option on the Go to Record step. 

Going back to your description: I would expected a user would either select from parts that already exist, or click [New...] to create one. Then, if you want to make sure the part they are trying to create does not already exist, I would suggest you use either a find or a relationship. Or, if you have a value list of the existing parts, you could use the FilterValues() function to see if the entered item is in that list. None of these require a loop. 

But perhaps you are doing something different. As I said, I did not understand your description and I don't see where you are in the workflow.

 

 

[Gismo1233]

Hi,

Yes it is the same question as on Claris community, for some reason, that website has been blocked in this country and I could not read the replies, the joy of traveling 🙂. FM Forum I could access so I reposted my issue

Yes in the orders layout, the user can select a part number from the parts file, if the part does not exist, it can be entered manually. If a part was entered manually, I want that part to be added to the parts file.

[comment]

8 minutes ago, Gismo1233 said:

it is the same question as on Claris community ... and I could not read the replies

That's not what I see: you posted there only a day ago. 

 

10 minutes ago, Gismo1233 said:

in the orders layout, the user can select a part number from the parts file, if the part does not exist, it can be entered manually

That's still too vague. Can be entered manually where? In the same field where they select an existing part? What would then be the trigger for the script?

I also see that you have variables for PartNumber and for PartDescription. Where would the description come from? The entire workflow is not clear. Surely they would not be entering a description of an existing part? So if they know that they are entering a new part, why is it necessary to check? And why would the order details table even have a field for part description, instead of showing the description from the Parts table?

 

 

[Gismo1233]

I have a list of parts in the parts catalogue with part description

In the order layout, you select the part number from a drop down and will autofill the description

If the part does not exist in the catalogue, the part number and description can be entered manually in the orders layout

 The newly enter part number and description must then be updated to the parts catalogue.

No, if the part exist in the catalogue, no description will be entered if the part was selected from the drop down

 

Yes I posted a few days ago, there are riots here and they tend to just cut off the internet and cellphone towers, I could not access Claris community at all over the past few days.

[comment]

49 minutes ago, Gismo1233 said:

If the part does not exist in the catalogue, the part number and description can be entered manually in the orders layout

I don't think that answers any of my questions.

Anyway, I already gave you 3 alternative ways to find out if a part already exists, and I think I will leave it at that.

 

[bcooney]

Do you know how to build a picker? I believe that is what you need. This may help. https://www.proofgeist.com/blog/2022/06/24/building-a-modular-picker-with-an-ontimer-script/