Update 2 rows on another form on submit
Hi, I have a form "movements" and another form "Stock" with different locations. When user enters 200 for "Item A" in form "movements" I would like to reduce the qty of "Item A" in form Stock for that item and location, and increase the qty of Item A in another location. Stock type will be chosen on the movements form. Stock will always originate in the same location and end in same destination. I tried the following for on submit, on success: if (input.Stock_Type
INSERT AN IMAGE IN FORM
Dear Sir / Madam I have uploaded one image in "Image Hosting site" and get a link. but when I tried to attached this image using link in my form thru ADD Notes. it is not showing Image. Link is http://i1170.photobucket.com/albums/r521/shivdutt/05b3d1a3.jpg Please check and advice me, how i can attached images in my forms.
Double Vision when editing a Script at Creator with Copy and Paste
Please look ar this video : https://berryforms.box.com/s/73fcc58a28b2b13fa485 Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Paypal & Customer Addresses - Can you help ?
How do I either :- A) Capture Billing or Shipping address and send these to Paypal when submitting a transaction ? or B) Let Paypal capture the address and read these back on a Creator View ? ------------------------------- My preference is A, but can live with B. At the moment the customer is asked for their address by Paypal and then on my Creator view I simply have a link to the Paypal Payment information and the address information is buried in a section called All Params. The address is in there
look up not working
hi i have tried and created two forms namely order form payment option my problem is when i use the option of look up in the 1st form for a field in payment options .. the field in the payment option form is not working
How to view two forms in one view?
Hello: I have one table with customer info (name, address...) and another one with the products purchased by each costumer. I linked both tables by costumer ID. I want to create a view for each costumer to show at the top of the view the costumer information (name, address...) and then the list of the products purchased by the costumer. Example: John Williams Phone 4242-5478 Adress: 25 1st street ----------------------------------------------------------------------------------------------------------
1 Report out of 2 forms
Hi all, I created a form where I can indicate a capacity per factory, per month (form 1). It looks the following: Month Factory Qty 01-Aug-2012 Factory 1 100000 01-Sep-2012 Factory 1 250000 In another form we enter volumes per week that are forecasted so far, like shown below; Date Factory Qty (SF) 01-Aug-2012 Factory 1 90000 01-Sep-2012 Factory 1 100000 10-Sep-2012 Factory 1 50000 I need to build a report where I can see e.g. how much volume has been forecasted and what the capacity for
Auto Populate of Fields isnt working correctly
I have an application that has all of the club information in it (club number, member number, member info etc.) It has multiple clubs in it and within those clubs it has multiple member number. There are member numbers that are the same within seperate clubs. For example I could have club 0259 and member 7 but also club 0176 has a member 7. What I am wanting to do is on a display_20_scores stateless form I have then choosing the club number from a dropdown, then I have them choosing a member
Hide Edit and View columns
I have a form that I would like to embed on my blog. But I don't want the Edit and View columns on the left to show before my first column shows with my compiled data. How can I mark these automatic fields not to show? Thanks. Earnest
logo
Is it possible to use different logo and favicon for each application? Thanks! V
iframe Zoho Creator SO
Can I zoho creator for my database & views on a Joomla or Wordpress site withou using iframe? I need the zoho database server name to be the same as my domain, is that possible? SEO friendly is the key.
formula function
I have a calculated field which needs an input from one of 3 formulas. Every time I input date into this field, I need to pick one of the 3 formulas. Do I need to hire a programmer to implement this?
Search Form with Date Range
I am creating a Stateless form with two date fields to search Start Date and end Date. I am using the follwoing OpenUrl Task. openUrl("https://creator.zoho.com/appowner/AppName/#View::Task_View?Start_Date= input.Start_Date;input.End_Date&Start_Date_op=58", "Same window"); When I submit the form I get all the records in the view with a message " invalid date format" What am I doing wrong. any help will be very much appreciated.
Hack to sort rows of a subform and pre-populate row fields that I want to preset
Not sure if Zoho have finally enabled sorting of rows in subforms. But the hack below worked for me. Basically i take note of the random order the rows are sorted. Create a hidden field in the table being used for the subform called Order_Index. I then just set the order index to the value it appears when the subform is displayed before implementing this logic. E.g The row I want to appear first might show as row 5 so I set the Order_Index for that record to 1. I create a map() which has a key
View Link to related table wont stay disabled
If a Link to a related table is enabled for a view in the Column Properties section and then disabled it does not stay disabled. When I go back to the column properties the link will be enabled. It can easily be disabled again. The problem is that I may be in the section to make some other change and not notice that it is enable. I have tested this with two different applcations. One using teh old UI and one using the new UI. ------ If I have the link enabled for a field set as a Group clicking on
Getting the ID of a subform entry in the same manner as an ID is returned by Insert Record
Hi When you create a record using insert Record you an get the ID back as a variable So when you create an entry or entries in a Subform any way to get the ID back in the same or similar fashion ? Thanks
CSV Export not working reliably with Explorer 9
What are the recommended browsers for Creator new UI ? Ariel Segall Cloud Mobile Forms Zoho Partner arielsegall@CloudMobileForms.com (877) 436-8133
Change display width for "view record" display in a view
When I view a single record using the "view record" feature in a Creator View, the two columns are much too wide, presumably because there are long interview questions and answers in my employment application form. Can this be controlled? Thanks Henry
Does Zoho Creator/payments allow for authentication?
I am working on a project where the client wants to be able to do a number of things with their database: Have donors (users) register their information, name address phone etc. via website. Purchase tickets for events that they have coming up via website. This could be via individual or table. Register attendance of people attending the events. Create reports of which donors gave over a certain amount etc. OK, so I get the basic idea of how zoho creator works and I have created some of the relevant
update multiple rows with fetch
Hi All, I have a form 'Stock' with 2 rows of data 'A' and 'B' for different quality of same stock. Another input form will have values that I want to add to both rows on submit. by add i mean if row A stock has a column with 10 and the input for that column is 10, then the new value will be 20 in the stock form. I've got fetch working for one row A, but would like to know how to perform fetch and update for both on same submit? Should I perform a second fetch? Thx, Rob
Search ID by contains
Would be helpful if you can search the ID by contains, it is such a long number that typing it in complete for "is" is prone to errors i end up making a string version of it and storing it but for every form it gets tiring
Apply onClick events on Note field?
is there a way to apply onClick events on a Note Field?
Clear Picklist, Why can't this be used in custom button onClick?
Clear Picklist is a client side function. Why can it not be used in a custom client side button? I get this message. Error at line 73 : 'hide | show | enable | disable | clear ' can be used only in 'on load' and 'on user input' actions I would think that onClick on a stateless form custom button would be considered a 'on user input' action. tt
Data order in view
Hi, Created a chart as a view. With on the x-axis the date. But it shows the dates in an unordered fashion: 4-feb 11-feb 3-feb Strange? I would be obliged if you could give me a hint where to look for to get it ordered by date.
In ZoHo Creator - how to add a column
Have a large spreadsheet that will grow to 100,000 records and need to know how to add columns should we need to down the road for new data tracking. How can we add column without starting over with new spreadsheet? Thanks!
Need urgent help: import merge
Hi I have accidentally erased the contents of one column in over 4000 entries. I have an excel backup but when I import, it tries to create new entries rather than merge to the existing ones. How can I merge the missing point to my existing entries? Thanks
How do you export a report as a PDF with the filters intact?
Hello, I want my users to be able to export reports to CSV, XLS, or PDF. I see that currently only PDF is supported. However, even this functionality is severed limited if the PDF doesn't preserve the filters that the user has set. Is there a way to work around this issue? Or is this already possible and I'm just missing it? And/or can this be added as a feature? Regards, - Kevin
Summary Box Sizes
Hi! Wondered if you can help me. My view for the forms is on Summary (The box) But why are some of them bigger than others? (Some are small and some are stretched, even though they hold the same information?) Thank you for your assistance.
Update record in another application dropdown box
Dear Sirs, I am currently working on Zoho Creator to set-up a database for product samples. I have 2 app. Both with only one form and one view. The first app is to create new samples from a form (Create_Sample) or view/modify/delete them from a view (View/Modify_Sample) Sometimes, we need to pack several samples in one box (to send them to another place for example) So I have a second app in order to create a new box from a form (Create_Box) or view/modify/delete these boxes from a view (View/Modify_Box).
Inserting table field in a form
Zoho Creator has various basic fields to drag and drop onto the form, but I have found no way to insert a simple table into a form. I hope to create a table with two columns and five rows. Under the first column will be a list of car brands (Ford, Chevy, Dodge, Nissan, and Honda). Under the second column will be five cells for the user to input the number of each brand sold during the month. Is this possible in Zoho? Thanks for your help!
Add CSS control
I like Zoho and it's features, but the fact I can't adjust the look and feel of the embedded application to match my site's look and feel makes the thing unusable. I can't even adjust the width properly on the iframe, Zoho's formating overrides!. So, I can't use it, it doesn't let me do what I want. cjmcqueen
CSS in Embedded Views
How can I use a custom CSS file in an embedded View? Thanks!
Customize Permalink Form Properties and Look and Feel Missing
Though the Help text and graphics show it, there is presently no option to customize the form properties before pasting it into a website. It is missing from the form. Has it been taken offline?
Reports and Views jpg.
I wish Zoho Creator could send views as jpg. and also reports as jpg. why is that not supported and also it would be great if the view would be exported the same way that it is displayed . It lets You set the display tab but when the view is exported or sent as attachment it doesn't come the same way.
7 DELUGE Tasks for integrating Zoho CRM with Zoho Creator
Zoho CRM and Zoho Creator continue to be two of our most loved services. To all of you who use both these services alike, we believe this will be good news. The integration started off with two DELUGE tasks solely for Zoho CRM. Now, there are 7 tasks that make communication between these two services, simpler like never before. To sum things up, you can 1. Create a record on Zoho CRM – For records submitted to a Zoho Creator application, you can create a corresponding record on Zoho CRM too. 2. Fetch
Field order in view
Hi, I made a form, added some items, added and changed the place of the different fields, but in the view the original order is kept. Is it possible to change the place of the fields in a view? Thanks JM
Problem with Custom Filters in embed view
Hi, I have created an app (with a free plan) using Custom Filters in some views. It runs propertly accessing the App throught Zoho Creator, but It doesn't in embed code. Selecting the filter the view's update delays forever and does not show results. Anyone knows why? Is there any solution? Thanks, Jordi
Parameters and HTML pages?
Can you pass a parameter into an HTML page (with an embedded view)? I would like to search my database for a specific record and then display my HTML page with the embedded view, (I dont want to write the HTML code if possible as the embedded view is all that I need. Any examples much appreciated.
Creator Craaaawwwling this morning...
Everything seems to be working, but at a 1-3 minute load per page. Not my connection I believe, as other sites are working fine.
Subtotaling Multiple Records from a different DB
In Zoho Creator, I have a Project DB with each project having a unique ID. I have another DB for Price Estimates of various elements of a given project-- each estimate is entered separately as a record in the Price Estimate DB with a Project ID pulled from the Project DB. So, in the Estimate DB I have several records with the same Project ID. How can I have the SUBTOTAL of all the Estimate records with the same Project ID appear in a field in the Project DB? Thank you!
Next Page