Has anyone else experienced some strange behavior with Strings in Deluge recently?
I have a picklist item that I match to a string value in some if/else statements. Example: if(input.picklist == "Test") { info "Foo"; } else { info "bar"; } When input.picklist = "Test", I still get "bar" . I had two separate statements that
Dropdown value selection on Field
I am having a form in which two fields are there: 1. First field contains two values 2.second field is a dropdown which contains 10 values. i want to select a value from first field and on the basis of that field only the values which are related to that
List function format
Hello, I have this scenario: codesFormA = input.Multiline.toList("\n"); codesFormB= List(); for each line in FormB[ID == input.Lookup_Field_Name] { codesFormB.add(line.SubformB.Code); } My question is why codesFormA returns: 1,2,3 And codesFormB returns
Copy value integration field
Hi, I have an integration field with CRM to look up account names, I want to copy these names to another field but every time I do it I get an ID. I have tried like this: input.other_field = input.integrationField;
submit button on top of form
I have a form with many fields. The user needs to page down 3 times to get to the bottom. I've arranged the fields so the important fields are near the top. Most users will never need to enter information in the fields near the bottom of the form. Is it possible to create an additional Submit/Cancel button on the top of the form? Currently all users need to go to the end of the form just to hit Submit. Thanks Herb Wexler 222.PreventingMediocrity.com
CALL A WIDGET ON AN IFRAME
Hello a question, how can I call a widget in an iframe of a page, without using the widget option Which route do I add here so that the widget that I need to visualize appears? I want to use this option, is there a way to do it?
Open subform as popup from report button
Hello, I have a form that has a subform inside, this subform I want to fill it when I press a button on the report page and then save this data in the record. I have seen some examples in other topics but it is not clear to me because some have different
Create reports using SQL queries
Create reports in zoho creator using SQL, to save fields in a form, when you want to make indicators or calculate the difference of dates (days, month, year) and instead of saving the information in a field to view it in the report, it would be super
Logging and debugging
Hi, Is there a simple debugging tool that works like nLog? log.warn(), log,debug(), log.error(). That kind of thing, it can capture variables and logs date/time/linenumber automatically. Destination can be configured. Logging level and scope should also
Photo session application with Zoho Creator is it possible?
Hello, I want to develop an application to automate the whole process of photo shoots. This is the process I need help with and I need to know if it is feasible with Zoho Creator: I take photos > I pass it to postproduction > the postproduction guys
JS SDK - I can't execute from other route than index.html
I am working with a React widget. When I try to use AddRecord from the JS SDK APIs from /index.html of my react app the request is successful. While when I try to use the same function from the same promise (initialised in App.js) but from different route,
Alternating the color of "batches" of HTML table rows
I'm posting to share the following code that Support gave to me that alternates the row colors of "batches" of rows. Use the following in an HTML snippet in a page. (Personally, I prefer to concatenate all of my HTML in an HTML variable then showing that,
Add a record in another form and adding new fields
Hello, I would like to ask how to do so that when an order changes status, for example delivery, automatically add a record in another form with some of that data and adding one or two new fields for example, file upload. In the end what I want is that
Creator API v2 Add Records - Not adding SubForm data
I have a formula in creator where I am trying to enter a new record into another creator form. All of the fields in the main part of the form pull in without issue but I cannot insert any subform data into a new record, or udpate an existing record using
How to Get the URL of Host Site in Creator Form Field
I am hosting a Zoho Creator's form in a site through iframe code, and i need to access and store the URL of the same site in Zoho Creator form field. Can anyone please help me. Thanks and Regards
Custom export to XLS
Hi, Any ideas about how to create xls file using deluge? I have a "Quote" form which has lookup fields to other forms like "Customer", "items, etc.. The quote should have 2 options for export: 1 - PDF (record template) - V 2 - XLS - ? Thanks in ad
Add sub stage to Kanban
Hello, I am making an application for internal company use with Zoho Creator, I would like to know if there is a way to add as a kind of sub-state to an order. For example, I have an order in production but I want to indicate that within the production
All creator icons set to default
All of the icons for my menus have been reset back to the default ones. Anyone encountered this or know I can get my icons back ?
Changes to market place apps
We are getting close to pushing our creator app to the market place. However, I can't find anything about what our customers would be able to modify in the app once they've bought it. The reason for the question is that we are using conditional formatting
Zoho Creator search/get records
Hi im looking for some help... Im running a function in creator that search/gets records from CRM accounts: I need the search/get to filter from a boolean, the amount which is passed through a user input and then sorted by created time(desc). This is
Benefit/disadvantages: Adding an inline subform created in main form vs embedding an existing form as subform
Hello, perhaps someone can offer some perspective on this. I've found that adding an existing form as subform is easier to manage as I can access the data easier. If it's an inline subform created within the same main form I can't access a direct report
Formula field blank on load
I have a formula field that shows either the user selected "start date" or the maximum date already in the Dates subform, which ever is greater. However, whenever the form is opened for edit, the field is blank. Adding a date, or changing the start date
how to apply multiple subform total addition value in a single field?
Hello Everyone Please help me I am stuck in the Zoho creator I have made 3 different subforms and their Total Amount is available, I got all the total amounts of each form separate, but I want to perform one more action these individual values will be
Disable and Enable Button for Radio
Hello, I am wanting to make a button that will disable all my radio button on a certain part of my form. These radio buttons send forms to an email and would like to add an option to just disable it with one push of a button. I know it can be scripted
Combine 2 fields into 1 field.
I need to combine 2 fields, one of which is an auto number field and the other is a single line text field. I tried using the following syntax in the workflow: input.SKUID = toString(input.SKU) + " - " + toString(input.Order_Type); but my output is as
Calculating a field value based on 2 other fields
I have put below into the workflow for a subform but its not giving the right result. Approximate cost field needs to be calculated based on Lump cost and Number of airstrips. Please assist. if(Number_of_airstrip != null) { input.Approximate_Cost = input.Lump_Cost
Conditional Print and PDF Template for Reports
Hello, I hope you all are safe and sound. While I like the pdf and print template feature, I feel that a new feature to set template based on conditions should be enabled. The Example Scenario is like this: Let's say there is an invoice template which shows the status of payments. Currently we will have to create multiple reports and set print / pdf template. It would be easier if we link different template to the status of the invoice, so that creating and maintaining multiple reports can be dispensed
Send mail and attach pdf
Hello. Using creator for invoicing. Wanting to send pdf invoice via email from app via "Send mail" fuction. Is it possible to name the pdf file based on data in a field? Thanks! Arlan
attachements to send mail : correct pdf filename
I also have a send mail function with the record summary attached.; But i cannot change the record summary file's name. Strange as i am able to give the pdf a name thru URL but not thru senmail attachements. Any ideas ?
Make field auto number visible on form load
Greetings, I hope find all well and safe! I have added a field type Auto Number on a form. I want to make this field visible on form load. I already have tried with a workflow to show the field on form load, but the field is still not appearing. Can someone
Automotive Repair Service Application?
I am looking for someone to create an application to be integrated into Zoho that will allow appointment scheduling, selling products and services in packaged or individual format.
Resending the email for customer portal
Hi, im wondering if its possible to resend the email for the customer portal through deluge. I understand you can do it by selecting a customer in settings and doing it through there, but id like to be able to set up a response so it can be resent by
Style the forms and reports in your CSS
I did a simple trick. - On a form, added a ritch-text field called pageStyler (Admin can only view) - Added a deluge on load as - input.pageStyler = "<style>#zc-component { background-color: yellow;}</style>"; - Login as Admin and submit one record against the form Now this makes my form width 100%. I need this for a huge form. However, I would suggest override the CSS with extreme care.
Whats-app Integration with Zoho Creator using twilio
Whether two way integration between zoho creator and whatsapp is possible using twilio ?
SMS Twilio Response
Hi Everyone, How does Zoho creator handle a response from Twilio is an SMS is sent and then the user replies. With Twilio the they have php, ruby, C#, javascript, erc. But how does this integrate with Creator in order to handle a respose?
Inbound/Outbound Twilio Calls
Is it possible to integrate zoho creator with twilio to receive inbound calls and make outbound calls? If so, how would i go about doing this?
Receive Twilio Messages in Zoho Creator V2
Hi, I am unable to figure out how to post sms messages as records in zoho creator. I've taken a look at this post but because of the new API v2, I'm not sure this will work. Can anybody be kind enough to walk a dummy through the process of creating a
URL for record summary as PDF
Hi, Is there anyway to access a Record Summary as PDF directly the same way as you can view the summary direcly in the browser ?: The way I am accessing the Record Summary in the browser right now: https://creatorexport.zoho.com/<username>/<app-name->record-summary/<view-name>/<record-id> Thanks!
Renaming Report - Report Title doesn't "stick"/save
Does anyone else have this problem? When renaming a report, a report title change doesn't stick/get saved. The report link name "sticks" more often, but that process's reliability isn't 100% either.
Google maps in creator
Is there a way of embedding a google map inside creator with it being able to search near by locations once an address is entered? I have some contractors that do some servicing for me and I would like to be able to locate the closest one once I enter
Next Page