Transfer of data

Support, Troubleshooting, & Help
1

Hello Tulip community,

I have been trying to transfer data from one table to another. When I try to run the trigger, sometimes it works and sometimes it shows an error message. I’m attaching the images here for your reference.

image
image1920×1080 215 KB

image
image1801×840 161 KB

Is it a fault in my trigger ?
Any leads would be helpful.

Thanks,
Krish

2

hello @Krish, thanks for posting!!

you will need to ensure there’s a Record loaded in the Record Placeholder prior to doing a Data Manipulation.

this article: How To Modify Tables Within the App Editor | Tulip Knowledge Base - Support for Building Operations Apps includes useful information. if you add an Action to Create or Create or Load a Record prior to the Actions you currently have, you’ll be able to do the Data Manipulations. could you let us know if this works for you??

3

Hello @gio ,

Is this how you wanted me to place the create or load command ?

image
image1420×645 17.4 KB

If I do , so the values are getting stored in both the ID column and the Part no. column.

image
image801×581 20.3 KB

4

hello @Krish,

I would recommend moving the Create or Load Action to the very top of the Trigger, that way you can do the 1st Data Manipulation in the Trigger.

in the interim, can you confirm you’re no longer seeing the error message now??

regarding the value in the P05717, is there another value you’d like to store?? if so, you can modify the 3rd Action in your Trigger.

I will say that this new course in Tulip University that @John published covers a lot of useful topics to understand how manipulate data in Tables: Loading.

5

Hello @gio

I moved the create or load record to the top but the problem still persists.

image
image1501×712 19.6 KB

In the P05717, I want the value from the other table to store instead of in the ID column .

image
image1263×754 70.1 KB

6

Hey Krish,

Sorry we dropped the ball here. Following back up to see if I can help resolve this one.

You added the “Create or Load Record” correctly as the first action, and you are loading it into the “Current defective parts” record placeholder.

The issue is the second action is basically saying [Take the “P05717” field from the “NewEntry” record placeholder and store it to variable “currentWorkOrder”]. The issue is you haven’t loaded anything from the table into the NewEntry Record Placeholder.

So like you did when “create or load record” into the “Current defective parts” placeholder, you need to also load a record into the NewEntry record place holder before you can use the data from that record.

Does that make sense?

If not, we run office hours 3 times a week (Tuesday and Thursday mornings and Thursday Afternoon) and I can send you an invite to our next session. This is a great time to work 1:1 through any issues you might have,

Pete