creating a temp form based on field variable, then insert all records in the temp form into another form
creating a temp form based on field variable, then insert all records in the temp form into another form i keep getting an error, is my syntax incorrect? rec = SR_Import[Imported != "Yes"]; { for each row in rec {insert into PS_Work_Order_Purchase_Order [ Company_Name = rec.Company PS_Work_Order_Purchase_Order = rec.WO_Number Description = rec.WO_Description AFE = rec.AFE Site_Code_Location = rec.Location_Full Field_Ticket_Signer = rec.Field_Ticket //= rec.PS_Contact Attention_to_on_Invoice
Sign in Issues
I get onto Zoho Creator from my home PC, office PC, and my Ipad. I also can get on through my iphone through Safari without any problems. But I tried downloading the app for my iphone and though I am signed in, it says i "don't have permission to access. Please contact Zoho support." I am the owner of the app and the administrator and I find it frustrating that I can't get in. I tried calling support but never got a response. Thanks. Paul M.
Trouble calculating the number of days between two dates.
I have a last service field in a customer form. Using a formula field I'm calculating zoho.currentdate minus the last service date. (This is a date field) / 1000 * 60 * 60 * 24 The result gives me 169.95833334. I've changed it to a decimal field with a decimal length of zero (0). and get the same result. 169.95833334. If I change the field to a number (no decimals) I get an error telling me the zoho.currentdate is a bigint and and Last Service date is a date field. All I want to do is have a result
List Only Contacts relative to Customer
We have two forms, say Form A and Form B. In form A we collect basic info Account Name Contact Title Email. We also have 6 other fields for Contact2 Title2 Email2 and Contact3 Title3 Email3. Over in Form B the first field is Customer (same as Account Name in form A). What I hope to accomplish in a lookup field is once we select the Customer that in the next lookup field only the Contacts (Contact, Contact2,Contact3 ) relative to the Account Name will show and then once we select a contact their
Form filtered by zoho.loginuserid
I know that I can have a report in a section, and the report can be filtered to only show rows where an email in the report matches the zoho.loginuserid. If the relevant data is a person's profile, theoretically there would only be 1 row per user for their profile settings. So they don't really need to see a list .... Is there a way to include a form in a section, so that the form is filtered based on zoho.loginuserid? Or, is the 'solution' to use a Summary report, rather than a List report?
Script Error
The following fails to compile: fetchedNotices = Notices [Violation_ID == input.ID]; input.Resolution = (fetchedNotices.count()).toString(); Error at line number : 20 Form 'fetchedNotices' does not exist in this application If I remove the parentheses that were added by the system and use: input.Resolution = fetchedNotices.count().toString(); it works just fine. Bruce "Speedy G" Peaslee The World's Fastest Programmer
show records based on login
Our application contains records for several hundred customers. Each customer has an account manager assigned to them. (This is a one-to-many relationship, in which each customer will only have one account manager, but each account manager will have many customers.) Account managers should only be able to view/edit their own customers' records when they log in to the application. In the past, we have managed this by creating a separate view for each account manager, with a filter so that only the
Calendar Item Display to 25 Characters?
Hi Support, Is there a way to adjust the display of the items in calendar view to 25 characters length instead of 15? Please advise. Thanks, Egressmedia
Vertical list report
Hello, Can I create a vertical report but not as a pivot table but as a regular list? How could I achieved this? Thanks!!
default to current date
Is there a way to make date fields in a form or subform default to the current date (with the option to select a different date, of course)?
Slow access in China
I have a collaboration tool developed in Zoho Creator. People in the US/Canada and China are accessing it. People in Zhejiang, China, today told me that the access is very very slow, unbearable so they can't do their job. Is there a way we can go around this? The same people in the same location used to access Zoho Creator with decent speed. Thanks.
Can not copy Url and Image field contents to a Stateless Form
@ZOHO Creator Team: I have a Sateless Form ... in its on Add on Load section I have commands like ... thisClientProfile = Client_Profile [Client_ID == input.Client_ID]; input.Business_Name = thisClientProfile.Business_Name; input.Client_Email_Address = thisClientProfile.Client_Email_Address; ... and ... input.Website = thisClientProfile.Website; input.Business_Photo_1 = thisClientProfile.Business_Photo_1; ... etc. etc. ... When I render this
Multiple Fields in One Look up Field
In form A we have a field for Contact Name and Contact Email. Also in form A (in case the customer has more than one contact person) we have fields for Contact2, Email2, Contact3, and Email3. In form B, we have a look up field that pulls from the Contact Name field only and than auto populates that persons email in from B. Is it possible that the look up field in form B could also pull the data into it from Contact2 or Contact3 if data is present there and also populate the email field? Cheers!
setting column sizes in subforms and reports
I'm trying to limit the width of columns that appear in list view reports and subforms. The default width is often much larger than the field name or any data contained in the field, and it makes for a lot of undesirable scrolling just to read or enter data. For the reports, I've tried going to column properties and setting the width for each column there, but it doesn't work. For the subforms, I have no idea how to go about doing this--and I really need to limit the amount of scrolling across the
Custom choice for checkbox field
Hello there, I'm new to Zoho Creator so I'm sorry if my question sounds silly... Is it possible for a checkbox field to add user defined choices, in addition to pre-set choices? Like in: 1. Choice 1 2. Choice 2 3. Choice 3 4. Choice 4 - Example (specify): ................... 5. Other (specify): .............. Thank you in advance for your reply! Igino
HELP!!! filter lookup in subform android app
Hello. I'm having an issue using the set filter option. I have a lookup list filtered based on input from another lookup list on a subform. Works perfectly on the desktop but does not work on the android moblie app. The lookup doesn't populate the list. Anyone have any ideas? Thanks
Related List App and Prefilling Field
Hey All, I've been working on creating a Zoho Creator app that acts as a related list within Zoho CRM. Until recently we had trouble getting it added, but thanks to support, it's not linked up in Zoho CRM, and showing the records we want to show. That said, there is one minor usability quirk that I'm wondering if anyone know's how to work around. The "Add" form is "keyed" on the record we're looking at. (In this specific example, when we add a record to our custom app, it's keyed on the potential
Create, Embed, and Auto Fill a Form
Hello all, I am very new to Zoho Creator and am having some difficulties. I am trying to create a form so I can embed it and then autofill that form in correspondence with another form. I need help figuring out how to: 1. Successfully create the form (I'm trying to import it but it's not working, does it need to be a certain format?) 2. Code correctly so the form I create and embed will autofill in correspondence to another form that already exists Any and all help is greatly appreciated! Thank you
How to validate multiple fields within a form?
I have a form that has the fields "Name" "Email" "Mobile Number" and "Office Number". I wanted to validate that when they entered a Mobile Number they were entering 10 digits with no dashes so I coded this: Mobile_NumberFormat = input.Mobile_Number.toString().replaceAll("([0-9]{10})","correct"); if (Mobile_NumberFormat != "correct") { alert "Mobile Number Should Be 10 Digits, No Dashes"; cancel submit; } I want to do the same thing with the "Office Number", but I don't know how to say if
A few problems
Hello guys, I am new to zoho creator and I was wondering if it would be possible to allow a customer to enter their details via a zoho CRM lookup and make it fill in the rest of the form from this, for instance their Sales Orders, Purchase Orders etc. Thanks in advance for reading through and responding to this topic.
Autopopulate a field based on 'New' action
Hello, I have created a custom module that has a mandatory name field. I need to autopopulate this field with a default value 'BST' whenever the user clicks 'New' to create a new record. The user does not have to enter a value in the name field. It should autopopulate. Please help. Thanks, Imran
Cannot duplicate an application
I have submitted a support ticket and sent an email to support and there's no resolution yet after a week of waiting. When I try to duplicate an app, the screen message says "duplicating" yet nothing happens. I have also downloaded the .ds script file and then import the script, and nothing happens. Some of my other apps also suffer from this, but not all This is under account sigroup Fix this today! John M. Whitney a.k.a. buzzap
Populate a CRM (Products) field in Creator App
I am trying to achieve exactly what is in this SAMPLE APP from Zoho, minus the input.Quantity_Available. I am having issues with this and am a new Creator user so any suggestions will be greatly appreciated. Thanks!
Summary and paper size
How/where can I specify that, using the summary report, I'd like to print 2 records per page? Or 4 (2 across, and 2 up and down)? Is any of that possible?
URL for viewing details based on drop down
Hi Currently have 3 forms. 1. Company 2. Contact 3. JobDetails In the job details I have a lookup for Company_Name and Contact_Name from the corresponding forms. I need to create a link for users to be able to view details of each of the companies and contacts. I need a link for users to click on to view the details of the selected company from the drop down. So the users selects the Company from the company_name lookup and it shows them the details of that company. I tried a note field with a
Show / hide fields in stateless form depending on value chosen in lookup field
Hi What code do I use to show or hide selected fields on a stateless form depending on a value that is chosen from a lookup field in the same form? Thanks
can not copy/duplicate sample applications
Hi all, I recently started to use Zoho and am hoping to use sample application to learn faster. However, I could not successfully copy/duplicate the sample applications at https://creator.zoho.com/sampleapps/. The error message always shows me You have logged in as xxxxx@gmail.com. You are not allowed to access this application. I have tried to duplicate dozens of sample applications, none of them worked, but I can install free applications in Zoho market place. Is this due to the plan I have is
user dedfined choice on checkbox
Hello there, I'm new to Zoho Creator so sorry if my question sounds silly... Is it possible to have a checkbox field where, in addition to some pre-set choices, the final user is able to add extra choices not originally provided? Like in : 1. Choice 1 2. Choice 2 3. Choice 3 4. Choice 4 - Example (specify): ............ 4. Other (specify): .................... Looks like it would be a useful addition to the checkbox field but I'm not sure if this is possible to set at all. Thank you in advance for
Show/Hide fields on subform based on selection from dropdown on same sub form
Hello. I need to know how to hide/show a dropdown picklist on a subform based on user input on another dropdown on the same subform Thanks in advance! Arlan
URL links for forms and pages for an application going to the Marketplace
I have a new application (my first to go to the marketplace) and need to know what format should links be so they continue to work when run by someone who buys the application. Are there placeholders for the top URL segments so they always resolve properly. I'm not sure at this point what part of the URL changes once someone is running their version of the application. Thanks. Regards... Rick Davey
count rows in subform
What am I doing wrong? I just want to count the total number of records in the subform that meet a certain criteria and input that count into a field on the main form. input.fieldinmainform = count(Subform[fieldinsubform == "LBR"]);
Sub Items And More users!
Hello, I just signed up for the free account but am very excited about using Soho for all my invoicing needs for my company. There are two huge questions remaining before I would be able to move forward. 1) How close are you to adding sub items? I have hundreds of products and need to be able to break them down into categories to make adding items to an invoice user friendly. 2) Is there the possibility of adding more users? I would like to be able to have 12-16 users. Please let me know.
Pivot table based on multiple forms.
Hi, I want to create pivot table based on multiple forms. I have three tables as describe below. 1. Trainer: This contains details of all trainers e.g. trainer name and age. 2. Trainer's target: This contains planned work for trainer. So each trainer will have multiple entries month wise. e.g. Trainer1 - Jan 2014 - 5 trainings and so on. This form has lookup field for trainer from Trainer form. 3. Students: This contains student details, trainer name and training date. (Student data gets entered
Move value from subform to main form
Hi what's the syntax to take a value from a field in a subform and apply it to a field in the main form? thanks Kevin
Reports in Zoho Creator vs Zoho Reports?
What is the difference between the two (if any)? Is there an advantage of getting Zoho Reports if I already have Creator?
How can i open a published form in edit mode?
I have published a form. I need to display the form in edit mode.
Best Way to Archive Data?
My team has currently hit a dead end. We are trying to figure out the most efficient way to archive our data. Currently, the only way I know how to do this, is to have two separate forms. One is the “Current Bike Form” and the other is “Archived Bike Form”. On the “Current Bike Form”, once a certain criteria is met and when the submit button is pressed, it will add that record to the “Archived Bike Form”. While this method archives data, the data can get very redundant under the “Archived Bike
integrations: updating an event created from CRM calendar with new guests
Hello, I created an event from zoho CRM --> little plus sign --> new event. Currently it has no guests. I understand zoho.crm.updateRecord for updating titles and such, but how do I update that event from zoho Creator to add new guests to it? Thank you, Joseph
Bulk Edit - excludes one of my lookup fields
I have a form with lots of fields, some are lookups and some aren't. When I use the Bulk Edit, one of my lookup fields is not included as a field that I can update. Any idea why that one field is excluded???
Image Preview for linked file
I have created submission form for advertising. Due to the file size restrictions I have not been using the file upload instead of the photo field. I can not figure out a script that would link the file upload URL to the photo field. I have created a summary report that would would show the preview of the image. I apologize if this topics has been covered before. I may not be searching the correct terminology. Any suggestions? Thank you!!
Next Page