Form Schedule Did Not Run
I have a form schedule setup to send an email on a specific date (later than today). Send Queued Posts { Execute on POST_QUEUE_FORM.DELIVERY at 01:00:00 } POST_QUEUE_FORM contains a date-field DELIVERY. However, the schedule did not run recently as anticipated. I do have the frequency set to ONCE, since I only want one email sent. Am I doing something wrong? Cheers, John Whitney
String to int
I can't find out how to parse a String to an integer in the deluge scripting language. Hopefully someone out there can explain to be how this is done. Thanks
how do I get an e-mail when a field is updated?
I have a form with multiple fields. I'd like to get an e-mail anytime one or more of the fields are changed and SAVED. However, I would ALSO like the e-mail to say: 1. Which fields were updated (what they previously were and what they currently are) 2. Give me a link to that particular data-set I know how to send the e-mail on update, but I don't know how to pull out the variables that tell me the above 2 listed items. Any help? thanks! - Quan
Reset Total value on update
Hi All, My form has several fields for numeric values to be entered. At the bottom is a total field. I set an "on user input" script for each field as follows to update my overall total at the bottom: input.Total = (input.Total + input.FIELD1Value); field 2 value etc.. This works fine and when I tab out of field the total updates. BUT.. If I go back to FIELD1 and change the value it adds this new value to the total also, so my total is way off as it has not reduced the initial value. Can someone
Want to put an intput field in Views
Hello Sir, I want to put a text field, in the views. After entering the value into that text field, that corresponding record should be updated. if this is not possible, Please try to tell me any other option.
Application Database Alternatives
I would like to create an application using Creator.......my issue.....my application database will be very large.....using Creator's database could get expensive....is it possible to create a appliaction within Creator and leverage Z Reports as my database....or any suggestions.....also are there limitations using databases other than the Creator database? thank you
total of multiple forms
Hello, I have a total of 6 forms that are linked by a single registration number per group of people. Each form contains a sum of money that is tied to the registration number. How do I create a sum across multiple forms so that it gives me a grand total of how much that person has cost me (incidentals, hotel room cost, food costs, etc). Thanks
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?
link between form and subform
Hi, What is the link between a form and subform? "If I embed a sub form into a main form and enter multiple records on the subform, how are these multiple records linked with the fields of the main form?" Please help. Thanks! V
How do you reference the value represented by a bidirectional field?
I'm trying to wright a custom schedule script that references the email addresses to send to, from a form where the email address is populated from a bidirectional relation. My script errors I assume because it is receiving the ID number from the bidirectional field instead of the actual email address value I have the child form display. Here is the code I'm trying to run: temp=""; for each x in CRS[Received == false] { temp = x.Report_Type; for each e in Test_Staff_Roles[Notice] {
Zoho Reports within Zoho Creator Tab
Is it possible to embed or <iframe> Zoho Reports within a Zoho Creator Application Tab? (not a report,chart or dashboard) But the ability to use the functionality of Zoho Reports within a Creator app... To give my users a more seamless experience? Both products are great....
New product update notice - in precreator.zoho.com
Hello All, We have come up with new set of features/enhancements. It is available in our beta server https://precreator.zoho.com . Noticeable changes: Improved Calendar view Provision to specify event/task Start and End date is supported (to be configured in design mode) Supported Week & Day in addition to Month view Refer the example view below Resize and Drag & Drop to update the event time Radio and Checkbox field can display options in multi-column layout (maximum of 3 columns) In addition to
Modify existing record and save as new record.
Is there a way of opening a record in edit mode and saving it as a new record? What I want to do is use the data from an existing record, modify it, and save it as a new record in the table. Any help would be appreciated.
Zoho Creator Payment - pass other data to PayPal?
When I use a payment form option, is there any way to pass additional fields through to PayPal besides the Item Name, Quantity, and Amount? We are trying to track all of our PayPal purchases through the use of SKU's (stock keeping units) corresponding to our internal account numbers, so I'd like to be able to pass an Item ID field through to the PayPal portal. Any way I can do that?
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
Next Page