Leaderboard

Would this help you? Go to your style, make a copy, then search your source/all in the style and find elementcbSubmitButton and add the property display: none; Assign the style to your page. Then go to your data page and add an HTML field and view the HTML source to add this code. <div align="right"> <input onclick="myFunction()" type="submit" value="Submit" /> -Mark

Hi Vitalikssssssss, It worked, thank you for your help. I have one additional question: From the first form, I pass the lineid to link to the next form. So far, so good. From the first form, I also pass the brandid. In the second form (which is based on the models table), I can then retrieve the brandid as a virtual field. My question is: is there a way to look up the brandname in the brands table? That would be a "nice to have", not strictly necessary to make the submission work. In more general terms, I guess my question is: can I automatically look up a value based on a passed parameter in a table that is not in the table on which the DataPage is based?

Thanks for your detailed insight. I watched the "How to Set Up User Permissions" tutorial and it was very helpful. I think your Travel Company model might have one more level than I will have in my Financial Advisor model - and so I'm still struggling with whether I have a one-to-many relationship or a many-to-many relationship. It sounds like instead of having the Many Travel Companies > Many Travel Agents > Many Customers you have - I have Many Financial Advisors > Many Clients. I'm not sure I have that 3rd level - although I suppose I could structure the model that way if, for example, a particular financial planning practice or firm had more than one financial advisor. Neil

Hi, yes you are right, there is no option to connect sql server and caspio using data hub. One possible option - synchronize caspio and sql via API, however this is not the best option if you have limited amount of API calls per month. You would need a lot of API calls to keep 2 databases up-to date. I would recommend exporting data from sql server, import to caspio and manage the database in caspio.