Is it possible to alter baseline table in fsm. If yes , then how we can do that and if no , then please suggest how to add or alter column in the baseline table.
+28Hi
It is not possible to alter a baseline table.
What are your requirements? We might help you solve it.
Cheers!
+6Hi
It is not possible to alter a baseline table.
What are your requirements? We might help you solve it.
Cheers!
I want to validate 2 columns. 1 column exists in ESCALATION (baseline Table) but other one is not there. requirement is
e.g;
user_def1 data should be validate with user_def2 data. if user_def2 input value match with user_def1 data then, user_def1 data will insert into table. user_def1 column is input type.
+28Hi
Sorry, but I am not following.
Maybe give an example?
Cheers!
+6Hi
Sorry, but I am not following.
Maybe give an example?
Cheers!
The requirement is
in the mobile application there is a filed bus no. This is an input type filed. so, client suggested bus no should match with registration no.
So, need to validate two filed. Bus no filed is already there but registration no is not there in the table.
if I understood your requirement correctly, to validate that field in mobile application, you have to use a sync rule get the relevant data into the mobile application. Then using a client script on Validate event in the custom mobile screen, you can validate provide alerts to the user when they are trying to save the record.
+6if I understood your requirement correctly, to validate that field in mobile application, you have to use a sync rule get the relevant data into the mobile application. Then using a client script on Validate event in the custom mobile screen, you can validate provide alerts to the user when they are trying to save the record.
Thanks
Yes, I am using client script only. But how to validate .can you please suggest.
+28Hi
Sorry, but I am not following.
Maybe give an example?
Cheers!
The requirement is
in the mobile application there is a filed bus no. This is an input type filed. so, client suggested bus no should match with registration no.
So, need to validate two filed. Bus no filed is already there but registration no is not there in the table.
Again, I find it hard to follow.
If the registration number is not in the table, what do you wish to compare it to?
Can you provide a full scenario with data as an example?
Cheers!
+6if I understood your requirement correctly, to validate that field in mobile application, you have to use a sync rule get the relevant data into the mobile application. Then using a client script on Validate event in the custom mobile screen, you can validate provide alerts to the user when they are trying to save the record.
Thanks
Yes, I am using client script only. But how to validate .can you please suggest. Even I am using sync rule. can you please suggest or give any reference
+6Hi
Sorry, but I am not following.
Maybe give an example?
Cheers!
The requirement is
in the mobile application there is a filed bus no. This is an input type filed. so, client suggested bus no should match with registration no.
So, need to validate two filed. Bus no filed is already there but registration no is not there in the table.
Again, I find it hard to follow.
If the registration number is not in the table, what do you wish to compare it to?
Can you provide a full scenario with data as an example?
Cheers!
When we select "abc_bus" from the station/bus dropdown field, the user can proceed only if they add the "abc_bus" number in the bus number field. If the user does not add the "abc_bus" number, a popup alert will appear saying, "Please add abc_bus number only.
+6Hi
Sorry, but I am not following.
Maybe give an example?
Cheers!
The requirement is
in the mobile application there is a filed bus no. This is an input type filed. so, client suggested bus no should match with registration no.
So, need to validate two filed. Bus no filed is already there but registration no is not there in the table.
Again, I find it hard to follow.
If the registration number is not in the table, what do you wish to compare it to?
Can you provide a full scenario with data as an example?
Cheers!
When we select "abc_bus" from the station/bus dropdown field, the user can proceed only if they add the "abc_bus" number in the bus number field. If the user does not add the "abc_bus" number, a popup alert will appear saying, "Please add abc_bus number only. The bus number field is an input type, so how can we validate it? They've provided a data sheet containing registration numbers, and according to them, the registration number equals the bus number. So, they want us to validate the bus number either from the station/bus dropdown field or using the registration number.
+28Hi
How many values of bus numbers do you have in total?
I would recommend having a global code and syncing it to the mobile. On mobile have a lookup screen to that code table.
So you can choose only valid values that are in the code table.
Cheers!
Hi
Furthermore you should never alter baseline tables, because any changes you may make, will likely be reversed when doing an update. If you run out of user defs the best option would be to create an extension table to the baseline table.
Morris
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.