Connect Creator to Invoice
I have a Creator database that has client information. Is there a way to connect this information to Invoice so that I can create invoices by looking up the clients?
cURL to add record error not a valid form, but form exists....????
I am attempting to add a record to a form but I keep getting an error stating that the form does not exist, although I know it does, and yes I'm using the linkname, not the form name in my URL. $data = array( ‘authtoken’ => xxxxxxxxxxxxxxxxxx, ‘scope’ => creatorapi, ‘names’ => bob, ‘total’ => 12.50 ); # Create a connection $url = 'https://creator.zoho.com/api/xxxxxuser/xml/test/form/this_form/record/add/'; $ch = curl_init($url); # Form data string $postString = http_build_query($data,
Send mail from report
Hi everyone Is there a way I can send a mail directly from a report? Our company organizes students, and I would like to be able to send them a mail directly from the report generated. I am aware of the sendmail-function, but that seems to be a function sending only predefined messages. Grateful for your help. Regards, Gulli Ovesen
How to integrate zoho security with a custom user form
I have a 'Add Employee' form with Name, email and role fields.Is there a way to tie these to the zoho security thats under myapplication setting. I do not want my user going to the 'ApplicationSetting' to create users to access my app. Thank you Anand
Publish page with embedded form + privateLink parameter added
Hi there, I need to embed the same form on 3 different websites, all with different styling applied. I figured the best way to do that is by creating 3 html pages and embed the form in each. Problem: Can't get the form to show public in the pages. When not logged in I am getting login form on the place where the embedded form should load. I tried following these step: https://help.zoho.com/portal/en/community/topic/embedded-form-layout-changing-the-styling#2266000006278456 So I published the form.
Custom action button in HTML view
Hi, I have a HTML page where I embedded a view .I want to show the custom action button on that HTML view but I can't figure it how to do that. Could any one please help me what parameter I should use ( style based url ) . below is the code I htmlpage TV_Station_Report1() displayname = "TV Station Report" content <%{%> <div elName='zc-component' viewLinkName='TV_Station_Database' params='zc_Header=true&zc_AddRec=false&zc_EditRec=true&zc_DelRec=false&zc_DuplRec=false&zc_EditBulkRec=false&zc_Print=true&zc_Export=true&zc_Summary=true&zc_RecPrint=false'>Loading
Auto populate form from a custom module in CRM
How do I auto populate a form using Zoho Creator from a custom module in Zoho CRM. I know how to do this using the default modules but changing the module name to custommodule1 does not sem to work.
How do I add an ID to a subform longlist?
Hi, I have a query relating to subforms and how the data is stored and accessed. I have created two forms, A and B. Then I insert B as a subform into A. Now: 1) I add a record A1, with subform entries B1 and B2. The subform entries are stored as records in form B. 2) I add a record A2, with subform entries B3 and B4. They are also stored in form B. 3) When I view A1 or A2 the subform magically shows only those B records in the A record in which they were originally entered, i.e. B1 and B2 show up
How to redirect value from form to external site by using post method in zoho creator.
Hello I need to redirect data to external site. I am using OpenUrl function to redirect to external site. But it expose the data in Url. I want to send data by using POST method like in php. Please tell me how can I redirect to external site with parameter should be encrypted.
Custom Function / Action Button - On Report View
I am looking to make a custom action / function for setting the status of a task as done on a decision field on my form, i know there is a way to do this and that there is a sample application for it, but i cant find it to install it to my acct . can someone help me find it or post a link ?
Reports. Group by/ count. Show "out of stock if count(item)=0, "In stock" if count(item) > 0
Basically have a report showing something similart to this: ID Type 6524 A 8472 A 2145 B 3254 B 1254 B 2158 B 6528 B 1235 D Want to alter it so a get a report likt this: Type Count A In Stock B In Stock C Unavailable D In Stock Is this possible, anyone done something similar? If I use pivot table, I can get the following: Type Count A 2 B 5 D 1 But I do not want to show the actual count. Want just to show "In stock" (or "more than 2") Thanks.
Maximum Capacity check
Hi, I build a script that was supposed to check a field value on a related form (Maximum Capacity) and then compare it to the count of specific records. And show an alert if it was reached. See below if (input.Britcham_events != null) { Cpct = Britcham_events[ID == input.Britcham_events].Maximum_capacity; Trgt = Britcham_events[ID == input.Britcham_events].Target_nr_of_participants; cnt = Participants[((Status == "Attending" || Status == "Confirmed") && ID == input.Britcham_events)].count();
Accessing the identifier for getRecordById to work
In a workflow custom function I am looking to access the Contact ID from a CustomModule record. Here is what I have coded: ToDoCrm = zoho.crm.getRecordById("CustomModule4",input.ToDoId); controlid=ToDoCrm.get("35-Control"); client=ToDoCrm.get("35-Client"); contact_id=ToDoCrm.get("contactid"); This is where I start have problems contactinfo = zoho.crm.getRecordById("Contacts",contact_id.toLong()); This line fails email=contactinfo.get("Email"); account=contactinfo.get(("Account Name")); dos=contactinfo.get("Date
Channel Partner app
Has anyone used Zoho Creator to create any type of indirect Channel Partner management application/portal, of course, integrated with Zoho CRM? Thanks.
How to get users email id
I have configured Zoho signing with gmail. I have a 'Employees' form which has a users filed.I have the appearance of the field to display the email address of the uses. How do I get this user id field in other forms? I am trying to get the email address tied to the user in other forms. When I try to display Employee forms user_id, by default it displays the username and not the email id tied to that user. Thank you Anand.
Invite new user/resend
I haven't had much success adding users to my Creator app. I have the most basic subscription (no profiles). Here are the steps I take: Go to app setting, add user in "Users and Permissions" tab Go to the share tab of app settings, add user to the top level of the app Click Dashboard. Click "Share" on every object and paste in the username. Go back to "Users and Permissions" and delete the user because of what I read in this thread I have successfully added users in the past but I'm not sure how.
Linking Multiple Application
Hi Support, I have two Applications, App1 and App2. In App1 i have form called Form1 and in App2 i have form called Form2. In Form1, i have Name1, Email1 and in Form2, i have Name2 lookup field to Name1. I have succefuly done scripting for linking two apps, for example, in App2, if i select the Name from list, i can get Email2 automatically. But what I am trying to do is, when user loads the Form2, based on User login email id it need fetch the name from App1 and input in Name2. I have done this
Error Handling Best Practice
In a large and complex ZC app with functions often being called 2 or 3 levels down, is there a best practice for error handling? I think there are at least 3 requirements: 1) A status message - text to describe any warning or error condition [or indeed success]. Because the message may be produced 2 or 3 function calls down, it must percolate back up and be displayed properly to the user. 2) A status code - that can be tested to see if the function status is anything but 'Success' and may dictate
Is There A Version Variable? And Related Wants ...
Is there not a way to incorporate a "version" into the application so that in the future as users needing help that they can refer to a "version" number found by some means? (perhaps coded into report footers as an option) I'd also like to incorporate this "system variable" into various custom report templates so the user knows what version they are on and can compare to the version that might be on the marketplace. Granted, I have not yet delved into application distribution via Zoho Marketplace
"Set Filter" works in it's own form but not when it is a subform.
I have a form called Accounts_Form which includes subforms created from existing forms: Add_Edit_Sites (bidirectional link to Accounts_Form) Add_Edit_Contacts (bidirectional link to Accounts_Form) Add_Edit_Contacts has a Lookup field called "Sites" which looks up site names from Add_Edit_Sites and has a "Set Filter" (see screencap) to filter out only sites with the same account name from the Accounts_Form. When adding a new contact from the Add_Edit_Contact and selecting an Account from the lookup
Many to many relation in Parents to Children tables
I read in some older posts that this may not be possible, but i wanted to see if there is a work-around. I have two forms, one "Parents", and one "Children". A Parent record can have multiple children, but one Child can also have multiple parents (father and mother). So far I have setup a Main form "Parents" with a subform "Children". This seems to work only one to many since I cannot lookup existing children records in the subform, only add new records. Does this sound familiar and is there a work
SEARCH and SIGN IN
I have been having one separate database (all the same) that I can post that will not allow anyone to make any changes, AND one for only me to post and add and make changes. All of a sudden, all of my databases would come up as SEARCH ONLY (including me) which is what I want. And off to the right would appear SIGN IN. I could sign in and I could make changes but others still could not. Today, this all changed back to requiring me to have the two different databases to post. What happened ? I want
importing a spreadsheet
Are there restrictions to importing data from a spreadsheet? I am importing a spreadsheet from Google Sheets which has multiple tabs. On the import, certain tabs are missing columns. Does data generated from a formula not import? Are there other types of data that do not import? Scott
Send Mail on success issue
I have created a on success email script but it is not sending. Log says an error has occurred. None of the To and CC addresses received an email. here is the test in the mail script.
Fetch record, subform to subform.
I have a Form with a Subform . I do a fetch data from another subform (subform where I want to get the information is a subform blank, no way). When I make the fetch fetch only becomes the first entry in the first inning and need: First entry - first entry Second entry Second entry ... etc Would like to know if there are other ways to do this THAN A FETCH. THANK YOU! if (input.Cotizador_Multiple != null) { dat = Cotizador_Multiple [ID == input.Cotizador_Multiple]; for each i in R
Version?
I am working with the user amaio1968@hotmial in the instance of leandro@addtarget.com and I can not see the types of fields: file upload Subform Autonumber Formula Signature Is this instance an old version of creator? Thank & regards
Issue with Dashboard IT Asses Manager
Hi All, I was working in zoho creator in IT Asset Management. But suddenly Dashboard stop working. Can some one help out with this. Milinda
Creator image and file locations changed?
Afternoon, Were the file locations for images and uploads changed (link file locations) as a result of the upgrades/DDOS attacks? If so, is this permanent or temporary? Appreciate any clarification and thanks! Scott
Creator Form usable on IMacs
Hi I've recently had a creator form created for our client brief. It works perfectly on a computer, tablet etc but when I try and look at it on my 21' imac its almost impossible to use. Can someone please give me a couple of suggestions.....
sendmail attachment
Hi It is posible to send pageas pdf as attachment in sendmail function?
ZOHO CREATOR ERROR 522 CONNECTION TIMED OUT
DEAR ALL, I HAVE THIS ERROR. I CHECKED MY INTERNET SPEED IT IS VERY GOOD NOW. WHAT IS GOING ON. MY ALL APPS STOPPED IT WORKS VERY SLOWLY OR I HAVE THIS ERROR FROM MY USERS. VERY VERY VERY URGENT SOLUTION!!!
Creator down again...
I assume you are aware that creator and other services are down again. That's two days in a row... Also the whole status.zoho.com thing is never correct im not sure the point of that site. Whole office sitting on their thumbs again... ETA?
Without using & I need to write php code for Zoho Creator
(Previously I was using the URL of Zoho Creator in my PHP code which was on XAMP but now I am not allowed to use any &) I need to make database in Zoho Creator. (I will do it) I need to write PHP code to apply business logics on that data. I need to apply CRUD functionality and return output in JSON. Kindly help me in letting me know that how I would write PHP code in Zoho creator as I am new to Zoho Creator.
Feature or Solution Request: A non-cubersome time field
Hello I created a simple time clock app for a client that allows them to enter and clock in and clock out and then auto calculate hours worked. Currently using the date/time field. I am getting so many complaints on the hard to use time entry (i.e. clicking and or dragging to get hours and minutes) Does anyone have a more elegant solution? Dear Zoho: Please consider fixing this, hardly usable in my opinion.
Slow response from Creator
Anyone else experiencing very slow response times from Creator applications today ?
Creator and Amazon MWS?
Hi, I run an e-retail business and sell on Amazon.com and other marketplaces. Currently I run most of the business using Excel. I make updates to Amazon using CSV file imports from Excel, and also receive Amazon reports as CSV files. All my sales analysis, forecasting, P&L etc. is also done in Excel, driven by this data. As this involves a lot of repetitive manual work to import/export data, I'm considering moving to a database-driven system and am considering using Creator. I'd like to use the
Access to my page from Mobile phone
Hello again! Pls, tell me how to access below to under url? from mobile. http://creator.zoho.com/global_share/test1 Yes, I can access my mobile. Cause, I am administrator. Any other administrator can not access? I want to show my url all mobile user. If you know...Pls, tell me.
Embedded Form Not Working - This Connection is Untrusted
creator.zohopublic.com uses an invalid security certificate. The certificate is only valid for the following names: *.zoho.com, zoho.com (Error code: ssl_error_bad_cert_domain) Receiving message where embedded forms have been functioning Screenshot - http://cl.ly/image/0C1r2102092j This Connection is Untrusted You have asked Firefox to connect securely to creator.zohopublic.com, but we can't confirm that your connection is secure. Normally, when you try to connect securely, sites will present trusted
how to define openURL function with ID of current record
In my reports i want a VIEW button to show the record much like the "View Record" button does in the most left column. Just to have a quick link to view the record in a popup. My function looks like this: void view_tmrt_record() { openUrl("/record-summary/test_report/"+ input.ID +"/", "Popup window", "height=500,width=500"); } but it gives the error 'variable ID not defined' . I thought input.ID automatically fetches the ID of the current record. Thanks for any feedback
sub form link to main form
Hi team, Note: (In lookup only one column possible to see, but i want see more than one column in a result set, tats y i selected sub form) I want to show my search results in sub form ex: I entered Location in 2nd form , then it result will come from 1st form and it showing in Sub form. If it's possible, any one help me to solve this ? Thank you,
Next Page